thursdaysgeek thursdaysgeek - 1 year ago 97
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

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download