select * from sotrudnik left join kabinet on kabinet.id_kabinet = sotrudnik.id_kabinet
left join dolzhnost on dolzhnost.id_dolzhnost = sotrudnik.id_dolzhnost