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'
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.