SQL left join mit Bedingung

[Uwe Raabe]

Sinngemäß:

SQL-Code:

SELECT KAT_ID, DOC_ID from Kategorien
LEFT JOIN zeitschriften ON DOC_ID = ZEIT_ID AND KAT_ID = 1
LEFT JOIN buecher ON DOC_ID = BUCH_ID AND KAT_ID = 2