Sql Server 2005 --What means *= in SQL statement

What mean *= in Sql statement like below ?

Select Table1.FieldA,  Table1.FieldB, Table1.FieldC from Table1, Table2

where   Table1.FieldK *=  Table2.FieldK

and Table1.FieldB in ('PT1',  'PT2',  'PT3') and Table2.FieldK is null


Thanks
niceguy971Asked:
Who is Participating?
 
aplusexpertConnect With a Mentor Commented:
*= refers as Left Outer Join
whereas =* refers as right outer join
and only = refers inner join in sql

You can use this operator in where condition in place of taking join.

Thanks...
0
 
appariConnect With a Mentor Commented:
this another way of doing outer join .

you can write the above sql using left outer join as follows:

Select Table1.FieldA,  Table1.FieldB, Table1.FieldC from Table1
Left Outer join Table2
 on Table1.FieldK =  Table2.FieldK
and Table1.FieldB in ('PT1',  'PT2',  'PT3')
where Table2.FieldK is null
0
 
sarabhaiConnect With a Mentor Commented:
old version refer *= as
LEFT OUTER JOIN

and =* as RIGHT OUTER JOIN
0
 
niceguy971Author Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.