----
[[:hobby:development:sql:select:inner_join_left_outer_join:sample|{{ :hobby:development:sql:select:inner_join_left_outer_join.png?300 |}}]]
----
<sxh sql>
SELECT *
FROM Table1 T1
	INNER JOIN Table2 T2 ON T1.IdT2 = T2.IdT2
	LEFT OUTER JOIN Table3 T3 ON T1.IdT3 = T3.IdT3;
</sxh>