CODEWITHSUNDEEP
sql-server
Muthukumar
Muthukumar

Reputation: 9579

What is the functionality of conditional statement *= in T-SQL

I found a piece of SQL code which uses *= as a conditional statement. Can some one provide some hint about it?

SELECT  *
FROM     TABLE1 A,TABLE2 B
WHERE    A.ID *= B.ID

Upvotes: 1

Views: 70

Answers (1)

podiluska
podiluska

Reputation: 51494

It's an obsolete style LEFT JOIN.

You should use this instead

 select * 
 from
     TABLE1 A
          left join TABLE2 B 
          on A.ID = B.ID

You may also find this useful when updating your code

Upvotes: 4

Related Questions