Question on sql syntax: *=

Question

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 1

*= (LEFT OUTER JOIN)

=* (RIGHT OUTER JOIN)

But rather make use of the LEFT/RIGHT JOINS

Answer 2

*= indicates left-outer join and =* indicates right-outer join.

EDIT:

I had my joins mixed up, have been corrected.