DELETE med LEFT JOIN

MySQL 4.1:

DELETE FROM user_party WHERE user_id NOT IN (SELECT id FROM user)

ældre MYSQL prøv:

DELETE FROM user_party USING user_party LEFT JOIN user ON user_party.user_id=user.id WHERE user.id IS NULL

jeg får en fejl... hvad gør jeg galt?

mysql_query("DELETE FROM $DB.user_party user_party USING $DB.user_party user_party LEFT JOIN $DB.user user ON user_party.user_id=user.id WHERE user.id IS NULL")or die(mysql_error());

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'user_party USING electrobeat_dk_db2.user_party user_party LEFT

ups...

mysql_query("DELETE FROM $DB.user_party user_party USING $DB.user_party user_party LEFT JOIN $DB.user user ON user_party.user_id=user.id WHERE user.id IS NULL")or die(mysql_error());

Hvilken version af MySQL ?

jeg bruger under 4.0.2

jeg har fundet fejlen :) jeg skal ikke skrive user_party efter DELETE FROM $DB.user_party

lav et svar :)

ok