-
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
-
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
-
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
-
Forum Rules
|
|