-1

What is the better alternative way for using *= join in MS Sqlserver 2008 ? Any better alternative available for this join ?

Chandralal
  • 559
  • 2
  • 11
  • 26
  • 1
    http://stackoverflow.com/questions/13382038/operator-in-sql – test Jul 07 '15 at 20:51
  • Could you elaborate? Maybe take a screenshot. You may be referencing an outer left or outer right join. *= is an old way of writing an outer left join. – Billy Norbu Jul 07 '15 at 20:53

1 Answers1

1

It's an (old) way of writing a left (outer) join. You can write

SELECT * FROM TableA, TableB WHERE TableA_ID *= TableB_ID

which has the same meaning as 

SELECT * FROM TableA LEFT JOIN TableB ON TableA_ID = TableB_ID
GolezTrol
  • 114,394
  • 18
  • 182
  • 210