Sql Server SELECT statement using '=*'

I inherited some code which uses a dynamic Sql Server SELECT statement. The statement uses an Equal Sign, Asterisk (=*) as part of the WHERE clause like this:

SELECT
LocalChangeBoard_Sign_RFC_Parm.LcbBoardName,
RequestForChange_LCB_Signature.LcbApproveFlag AS LcbApproveFlag,
LocalChangeBoard_Sign_RFC_Parm.LcbBoardID
FROM RequestForChange_LCB_Signature ,LocalChangeBoard_Sign_RFC_Parm
WHERE RequestForChange_LCB_Signature.LcbApproveFlag = 1
AND (RequestForChange_LCB_Signature.LcbBoardID =* LocalChangeBoard_Sign_RFC_Parm.LcbBoardID )
AND (LocalChangeBoard_Sign_RFC_Parm.ActiveFlag = 'A')
AND (RequestForChange_LCB_Signature.RequestForChangeID = @RfcID)
ORDER BY LocalChangeBoard_Sign_RFC_Parm.LcbBoardName
 
I have no idea what this does. Can you help?
stevenhugAsked:
Who is Participating?
 
Paul JacksonSoftware EngineerCommented:
=* is and old style way of doing a right outer join

http://www.gplivna.eu/papers/sql_join_types.htm#p6.6
0
 
Kyle AbrahamsSenior .Net DeveloperCommented:
http://stackoverflow.com/questions/983862/sql-server-operator

Apparently it's an implicit right join.

similiar to (+) in oracle.
0
 
Lee SavidgeCommented:
Its a legacy join syntax for specifying outer joins.

http://msdn.microsoft.com/en-us/library/aa213228%28v=sql.80%29.aspx
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.