Joins

[Former Member]

Hi,

how can i fetch data from 3 tables with a single select statement without using joins

thanks.

sagar

[Former Member]

Hi,

how can i fetch data from 3 tables with a single select statement without using joins

thanks.

sagar

[Former Member]

HI sagar,

u create a view and use it as a single table

if ur view is view1

then use

select * from view1.

i think they is no other way for ur requirement

<b>

Regards,

Azhar</b>