---- [[:hobby:development:sql:left_outer_join:sample|{{ :hobby:development:sql:select:left_outer_join.png?300 |}}]] ---- SELECT * FROM Table1 T1 LEFT OUTER JOIN Table2 T2 ON T1.IdT2 = T2.IdT2;