You can only delete from one table at a time. You can use a temp table to store the ids that you want to delete. You may also be able to use the OUTPUT clause of the first DELETE as input to the second DELETE, but I've never tried it.

Drew