CODEWITHSUNDEEP
sql-serversql-server-2008sql-server-2005
Mike
Mike

Reputation: 6050

=* operator in sql

I was typing along and fat finger something and when I typed 

=*

in the sql window (2008 SSMS connected to a 2005 server) it turned blue as a keyword.

I can not figure out, or google, what this does. I know *= but not =*

What does this operator do?

Upvotes: 8

Views: 16225

Answers (1)

Andomar
Andomar

Reputation: 238096

=* is an old way to write right outer joins. For example:

select  *
from    A
right outer join
        B
on      A.bid = B.id

Is written in the old style like:

select  *
from    A
,       B
where   A.bid =* B.id

Upvotes: 21

Related Questions