SQL : 3 verschiedene Tabellen zusammenziehen

[Bora4d]

Code:

SELECT t1.ID, t1.NAME FROM Table1 t1, Table2 t2, Table3 t3
WHERE (t1.ID=3) AND (t2.ID=t1.ID) AND (t3.ID=t1.ID)
ORDER BY t1.ART

Es geht auch so (bedeutet dasselbe):

Code:

SELECT t1.ID, t1.NAME FROM Table1 t1
JOIN Table2 t2 ON t2.ID=t1.ID
JOIN Table3 t3 ON t3.ID=t1.ID
WHERE t1.ID=3
ORDER BY t1.ART