hobby:development:sql:select:inner_join_left_outer_join [MLC Wiki]

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