Hello
I do:
SELECT *
FROM t1
LEFT JOIN t2 on col1=col2
WHERE t2.col3=1
Is the WHERE filter above applied to the t2 before the join or to the col3 column from t2 after the join?
Because it seems not to filter the after-join table.
How can I do each, i.e. filter the pre-join or the after-join table?
Thanks!