select required columns
from table1 t1
inner join table2 t2
on t2.city = t1.city
and t2.adress = t1.adress
and t2.work = t1.work
inner join table3 t3
on t3.city = t1.city
and t3.adress = t1.adress
and t3.[E-mail] = t1.[E-mail]

select t1.city, t1.adress, t1.work, t1.post_office_number, t3.e-mail
from table1 t1
inner join table2 t2
on t2.city = t1.city
and t2.adress = t1.adress
and t2.work = t1.work
inner join table3 t3
on t3.city = t1.city
and t3.adress = t1.adress
and t3.[E-mail] = t1.[E-mail]