Tabellen vergleichen

[Thomas]

keine Ergebnisse -----

SELECT alt.interpret, alt.titel
FROM top100 AS alt
LEFT JOIN top100 AS neu ON ( alt.interpret = neu.interpret AND alt.titel = neu.titel )
WHERE (
alt.KW =10 OR neu.KW =11
) AND alt.jahr =2004 AND neu.jahr =2004 AND alt.interpret IS NULL  LIMIT 0 , 30