This is a discussion on How do can I use a LEFT OUTER JOIN on the resultset of a join? within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> I have a join of 4 tables: select * from a,b,d,c where <join conditions on a,b,d,c> I need to ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| I have a join of 4 tables: select * from a,b,d,c where <join conditions on a,b,d,c> I need to join the resultset with another table <e>, but some records of the resultet might not be in table <e>, but I want to see them. Whit Oracle syntax it works: select * from a,b,d,c,e where <join conditions on a,b,d,c> and c.key = e.key (+) But I cant figure how to use the LEFT OUTER JOIN syntax: select * from a,b,d,c left outer join e on c.key = e.key where <join conditions on a,b,d,c> I returns all the rows of <c>? |