CODEWITHSUNDEEP
mysqlsql-servervb.netvb6sybase
user1506228
user1506228

Reputation: 45

SQL *= statement (outer join)

currently, i am converting VB6 to VB.NET. After conversion, i want to insert / select in SQL but i need to know what is the meaning of my sql statement.

My Statement:

XXX  where  adj.reasonid *=  re.reasonid and (status <> 'A'OR action = 'H')

Can someone know *= mean? and

in (status <> 'A'OR action = 'H') is that mean either one condition can select the data?

Upvotes: 1

Views: 221

Answers (2)

Vishwanath Dalvi
Vishwanath Dalvi

Reputation: 36631

It's old syntax for Outer Join in sql server.

SQL Server has long supported two forms of OUTER JOIN syntax, the ANSI syntax (using LEFT OUTER JOIN, RIGHT OUTER JOIN, etc.), and the simplified T-SQL syntax (using= and =).

http://www.forta.com/blog/index.cfm/2006/1/15/SQL-Server-2005-Outer-Join-Gotcha

In your code.

where  adj.reasonid Left Outer Join re.reasonid 
and (status <> 'A' OR action = 'H')

For in.

in (status <> 'A'OR action = 'H')

OR Operator only evaluates expressions until it find a TRUE result.

Upvotes: 1

Pablo Romeo
Pablo Romeo

Reputation: 11396

*= is alternate (obsolete I believe) syntax for left outer join.

Upvotes: 2

Related Questions