delete from t1 where no matching record in t2?

[sneakyimp]

i have a query that tells me which records in one table have no counterpart in another table:

SELECT xoc.onet_code, xoc.cip_code, c.onet_code,
c.title
FROM myplan_xwalk_onet_cip xoc
LEFT JOIN myplan_careers c
ON c.onet_code=xoc.onet_code
WHERE c.onet_code IS NULL

i would like to delete the records in xoc where there's no match in c. is there a query that will to this without also deleting records in c?

[Drakla]

DELETE FROM myplan_xwalk_onet_cip
USING myplan_xwalk_onet LEFT JOIN myplan_careers
ON
myplan_xwalk_onet.onet_code = myplan_careers.onet_code
WHERE myplan_careers.onet_code IS NULL;

Won't work on old versions of MySQL, think from 4.0.22 onwards, but can't be sure.

[sneakyimp]

you rock, dark one.

but my version of mySQL is old: 3.23.58

sigh

script time.