LEFT JOIN t2 on col1=col2
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?