Skip to Content
avatar image
Former Member

Joins

Hi,

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

thanks.

sagar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Aug 21, 2007 at 09:31 AM

    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>

    Add comment
    10|10000 characters needed characters exceeded