Outer Join In MS SQL

[LaCour]

In oracle you can do an outer join by adding a (+) to the field that is not required to have a value. How do you do the same in MS SQL.

Here is an example where clause in oracle that would work:
Where table1.record_id = table2.record_id
and table1.foriegn_key = table3.record_id (+)


Thanks in advance

Blair

 

[hneal98]

You can do it like this:

select * 
from 
  table1 t1
  inner join table2 t2 on t1.record_id = t2.record_id
  left outer join table3 t3 on t1.foreign_key = t3.record_id

 

[JonFer]

Minor point - The "outer" is optional meaning that "Left Join" by itself will work.

John

http://www.interautomateconsulting.com