Is there an easy way to populate a column with an INDEX/MATCH statement?

[robert_volk]

It's a JOIN. There are numerous examples in the SQL Server documentation.

You've posted a question that suggests you understand how JOINs work:

Do WHERE statements filter the pre-join tables or the after-join table?

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!