SELECT * FROM Table1 T1 FULL OUTER JOIN Table2 T2 ON T1.IdT2 = T2.IdT2 FULL OUTER JOIN Table3 T3 ON T1.IdT3 = T3.IdT3;