thursdaysgeek thursdaysgeek - 23 days ago 10
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
*= (LEFT OUTER JOIN)

=* (RIGHT OUTER JOIN)

But rather make use of the LEFT/RIGHT JOINS