sql delete

[ttuser4]

hi,

i want to delete records from one table (bays_jun18) where there are no associated records in the second table (loadup2). There are three fields - span, type, length - have to match, if they don't match then delete record.



Error

SQL query:

DELETE bays_jun18. * FROM bays_jun18 p LEFT JOIN loadup2 pp ON p.type = pp.type AND p.length = pp.length AND p.span = pp.span

MySQL said: Documentation
#1109 - Unknown table 'bays_jun18' in MULTI DELETE

 

[ttuser4]

never mind, this worked:

delete a . *
FROM bays_jun18 a
WHERE NOT
EXISTS (

SELECT *
FROM loadup2 b
WHERE b.type = a.type
AND b.span = a.span
AND b.length = a.length
)