Q:

How to join two tables with where condition

I have these two tables

If I do Select * from tab_salaries WHERE salary > 200
I will get

How can I JOIN these tables to get this table in the end? Thank you 

A:

Select s.*,e.name,s.surname from tab_salaries s 
inner join tab_employees e on e.customer_id = s.customer_id
WHERE s.salary > 200

