Ich hatte im Online-Handbuch (
HTML-Doku) von 4.0.5 nachgesehen:
Zitat:
1.7.4
MySQL Differences Compared to
ANSI SQL92
...
1.7.4.1 SubSELECTs
...
The queries:
SELECT * FROM table1 WHERE id NOT IN (SELECT id FROM table2);
SELECT * FROM table1 WHERE NOT EXISTS (SELECT id FROM table2
WHERE table1.id=table2.id);
Can be rewritten as:
SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id
WHERE table2.id IS NULL;
Vielleicht hilft dir das weiter
marabu