I'm trying to do a delete on two tables at once.
sucessfully does it with update,
UPDATE table1 INNER JOIN table2 ON table2.table1_id = table1.ID SET table1.whatever = Whatever, table2.whateveer = Whatever
is there a way to do this with the DELETE function
DELETE table1 INNER JOIN table2 ON table2.table1_id = table1.id WHERE table1.ID = 1
thanks in advanced.