SQL Syntax query

[nidgep]

Hi
Can anyone offer advice as to what the (+) entry within the following sql syntax is actually doing please?

[COLOR=blue]
	strSQL = "SELECT * FROM customers, cust_titles, cust_addr,cust_codes"
		strSQL = strSQL & " WHERE custcodes=code(+)"
		strSQL = strSQL & "  AND title=titleid(+)"
		strSQL = strSQL & "  AND customer=customerid"
		strSQL = strSQL & "  AND edate is NULL"
		strSQL = strSQL & "  AND customerid=?"
		set getCustomerByLink=ExecQueryRS(strSQL,Array(adNumeric,10,linkRS("customerID")))

[/color]

 

[SQLDenis]

looks like an Oracle Query
Specifies left or right joins if I remember correctly

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[nidgep]

thanks for the reply.

The answer was spot on, as I had just found it on microsoft tech net site.
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part2/c0761.mspx

strange this is though I found it within an ASP page that is making calls to a SQL Server database!!

Cheers anyway.