put columns in select listselect t1.city, t1.adress, t1.work, t1.post_office_number, t3.e-mailfrom table1 t1inner join table2 t2on t2.city = t1.cityand t2.adress = t1.adressand t2.work = t1.workinner join table3 t3on t3.city = t1.cityand t3.adress = t1.adressand t3.[E-mail] = t1.[E-mail]
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/