1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| SELECT Table1.Nom_Produit, Table4.Nom_Proprietaire, "Table1" AS [Table]
FROM Table1 INNER JOIN Table4 ON Table1.Id_proprietaire_fk = Table4.Id_Proprietaire
Union
SELECT Table2.Nom_Produit, Table4.Nom_Proprietaire, "Table2" AS [Table]
FROM Table2 INNER JOIN Table4 ON Table2.Id_proprietaire_fk = Table4.Id_Proprietaire
Union
SELECT Table3.Nom_Produit, Table4.Nom_Proprietaire, "Table3" AS [Table]
FROM Table3 INNER JOIN Table4 ON Table3.Id_proprietaire_fk = Table4.Id_Proprietaire
order by Nom_Produit
; |
Partager