Tabellen vergleichen

[Thomas]

SELECT alt.interpret, alt.titel
FROM top1002 AS alt
LEFT JOIN top1002 AS neu ON ( alt.interpret = neu.interpret AND alt.titel = neu.titel )
WHERE alt.KW =10 AND neu.KW =11

bringt 100 Datensaetze also eine KW