Delete records from table 1 that don't have reference in table 2

[Boris_Senker]

I have a script that doesn't delete records from one database when it should, and now I have to do this myself because database is big and causes problems on the server.

What I have is:

TABLE 1, field auction
TABLE 2, field id

so I would like to delete all records from TABLE 1 where the value of the field auction doesn't match the value of the field id in TABLE 2.

Can someone help me on this, please? I need to get this database cleaned.

Thanks.

[devinemke]

if your RDBMS supports subqueries then you could do:

DELETE FROM table1 WHERE auction NOT IN(SELECT id FROM table2)

[Boris_Senker]

My apologies for not mentioning - RBDMS is mySQL 4.1.

Thanks, I'll try this way 🙂