Question on sql syntax: *=

sql-server-2005 sql

*= (LEFT OUTER JOIN)=* (RIGHT OUTER JOIN)

But rather make use of the LEFT/RIGHT JOINS

sql-server-2005 sql

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

I had my joins mixed up, have been corrected.

sql-server-2005 sql

please replace that with modern LEFT OUTER JOIN .. ON syntax!!

left outer join *=
right outer join =*

CodeHunter