Search code examples
sqlleft-joinsap-ase

Difference between left join and *= in Sybase ASE 15


I need help to understand this matter, what's the difference between the 2 queries below, all I know that they don't return the same result.

Query 1:

SELECT a.col1, b.c1
  FROM A a
  LEFT JOIN B b
    ON a.col1 = b.c1
 WHERE b.status = 'Y'

Query 2:

SELECT a.col1, b.c1
  FROM A a, B b
 WHERE a.col1 *= b.c1
   AND b.status = 'Y'

Solution

  • Sorry to be a little bit late, but i found the solution: In the old syntax *=, the condition b.Status = 'Y' will be in the left join on clause, so to have to same result in the first query I just moved the b.Status = 'Y' to the "on" clause.