how can i fetch data from 3 tables with a single select statement without using joins
u create a view and use it as a single table
if ur view is view1
select * from view1.
i think they is no other way for ur requirement