getting the data from the specific row in the other query when creating a custom column

Hello 

I have two tables as below. I'd like to create new custom column (z) in Table2 and add a specific data from Table1.

I couldn't find anything on how I can do this... can you please help me?

Thank you