thursdaysgeek thursdaysgeek - 9 months ago 64
SQL Question

Question on sql syntax: *=

I have some older (broken) code that has a join using a *=

table1.ID *= table2.ID


Is this a left outer join or a right outer join? (My error message indicates it is one of those)

Answer Source
*= (LEFT OUTER JOIN)

=* (RIGHT OUTER JOIN)

But rather make use of the LEFT/RIGHT JOINS