How about something like
DELETE FROM MyTable WHERE ID in (SELECT t2.ID FROM MyTable2 t2, MyTable3 t3 WHERE t2.ID = t3.ID);
?
Anyway, check the SQL Reference manual, there are lots of examples of DELETEs.
|
Results 1 to 2 of 2
Threaded View
|
Click Here to Expand Forum to Full Width |