Results 1 to 3 of 3

Thread: Need Help -- How to make Outer Join

  1. #1
    Join Date
    Jun 2007
    Posts
    14

    Post Need Help -- How to make Outer Join

    Hi have three table , one table as master remaining two tables are detail. I want make outer join for these two details with master table ,

    table names table 1 master , table2 & table3 as detail

    table1(+) =table2 AND table1(+)=table3

    i got this error

    a table may be outer joined to at most one other table

    Kindly help me to frame query for this situation

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Use ANSI syntax which is easier to understand and less error prone.

    select column1,...
    from master
    left outer join detail1
    on master.keycolumn=detail1.fkcolumn
    left outer join detail2
    on master.keycolumn=detail2.fkcolumn

  3. #3
    Join Date
    Jun 2007
    Posts
    14

    Thank U

    Thank U lot for helpme to frame the query

    with regards,
    E.Ramkumar

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •