Der Oberförster: Zwei Selects verbinden ohne UNION

Beitrag lesen

SELECT w.name, t.texte, t.date, a.name FROM operator AS o
INNER JOIN text AS t  ON o.text_ID = t.ID
INNER JOIN waren AS w ON o.waren_ID = w.ID
INNER JOIN autor AS a ON o.autor_ID = a.ID
ORDER BY t.date DESC