Looks a bit like the old SQL join syntax: Select * >From table1,table2 Where field1(+) = field2
The + indicates an outer join. Here's a link describing the two: http://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:6585774577187 Sincerely, Dave Phillips -----Original Message----- From: Michael Dinowitz [mailto:[email protected]] Sent: Wednesday, May 09, 2012 10:20 AM To: sql Subject: strange where clause I'm looking at someones query and it has a where clause that looks like this: Where Person.per_id (+)= EMail_Recipient.per_id what is that (+)=? The MSSQL management studio dies on it. Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3447 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
