We help IT Professionals succeed at work.

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?
Comment
Watch Question

Kyle AbrahamsSenior .Net Developer
CERTIFIED EXPERT
Commented:
http://stackoverflow.com/questions/983862/sql-server-operator

Apparently it's an implicit right join.

similiar to (+) in oracle.
Software Engineer
CERTIFIED EXPERT
Top Expert 2011
Commented:
=* is and old style way of doing a right outer join

http://www.gplivna.eu/papers/sql_join_types.htm#p6.6
CERTIFIED EXPERT

Commented:
Its a legacy join syntax for specifying outer joins.

http://msdn.microsoft.com/en-us/library/aa213228%28v=sql.80%29.aspx

Explore More ContentExplore courses, solutions, and other research materials related to this topic.