Upgrading to compatibility 90 in sql server 2005

• VG-619426

  Hall of Fame

  Points: 3914

  More actions

  September 5, 2008 at 10:23 am

  #154699

  Hi,

  We are upgrading to sql server compatibilty level to 90 from 80. We need to make some chaged in our codes, whereever it is effected. One of them is , we have *= and =* operators are used, BOL says to replace this with OUTER JOIN. My question is operator *= is equivalent to Left outer join ? and =* is right outer join ? I can't seem to find any source on this.

  Thank you,

  VG

• Ken McKelvey

  SSCoach

  Points: 18853

  More actions

  September 8, 2008 at 5:19 am

  #868343

  It depends on the order of the tables. I prefer to think of the * being on the side where all the rows are returned.

  --eg

  SELECT *

  FROM TableA A

  &nbsp&nbsp&nbsp&nbspLEFT JOIN TableB B

  &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspON A.AID = B.AID

  -- is either

  SELECT *

  FROM TableA A, TableB B

  WHERE A.AID *= B.AID

  -- or

  SELECT *

  FROM TableA A, TableB B

  WHERE B.AID =* A.AID