I was wondering if anyone knew the Oracle equivalent of the Left Join in SQL Server.
Thanks,
Neil Fairweather
Printable View
I was wondering if anyone knew the Oracle equivalent of the Left Join in SQL Server.
Thanks,
Neil Fairweather
You put (+) on all instances of the optional table in the where clause, e.g:
SELECT a.x, b.y FROM a, b WHERE a.z = (+) b.z AND b.w (+) = 1