DELETE 要删的表tablename1
FROM
要删的表tablename1
join ( SELECT ID FROM 表2 bb ) tt on要删的表tablename1.id = tt.ID
DELETE 要删的表tablename1
FROM
要删的表tablename1
join ( SELECT ID FROM 表2 bb ) tt on要删的表tablename1.id = tt.ID