{{:wiki:icons:t-sql.png?nolink&90 |}} <fs xx-large>INNER JOIN and a LEFT OUTER JOIN</fs>
[[https://www.mlcortese.it/doku.php?id=hobby:development:sql:select:query_0003|{{ :wiki:icons:left_arrow.png?48|Torna all'indice}}]]\\
//<fc #5F5F5F><fs large>(Aggrega i dati da due tabelle)</fs></fc>//
\\
{{page>:hobby:development:sql:select:inner_join_left_outer_join}}

----

{{page>:hobby:development:sql:tbl1_tbl2}}

<thumbnail>
**Recordset risultante**

----
^IdT1^Name^IdT2^IdT3^IdT21^Color^IdT31^Food^
|1|Mauro|1|(null)|1|Giallo|(null)|(null)|
|4|Franco|1|(null)|1|Giallo|(null)|(null)|
|3|Marco|2|(null)|2|Verde|(null)|(null)|
|2|Andrea|3|(null)|3|Rosso|(null)|(null)|
|6|Francesca|5|2|5|Grigio|2|Carne|
|5|Giovanna|7|(null)|7|Rosa|(null)|(null)|

</thumbnail>