Solved

Sql Server SELECT statement using '=*'

Posted on 2012-03-13
3
348 Views
Last Modified: 2012-03-13
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?
0
Comment
Question by:stevenhug
3 Comments
 
LVL 39

Assisted Solution

by:Kyle Abrahams
Kyle Abrahams earned 150 total points
ID: 37715326
http://stackoverflow.com/questions/983862/sql-server-operator

Apparently it's an implicit right join.

similiar to (+) in oracle.
0
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 150 total points
ID: 37715329
=* is and old style way of doing a right outer join

http://www.gplivna.eu/papers/sql_join_types.htm#p6.6
0
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 37715333
Its a legacy join syntax for specifying outer joins.

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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now