Joining tables in DELETE statement

Can anyone please tell me how to join a table and a view to delete matching rows from the table?

Here's a sample of my problem. I have a SQL statement in the following fashion:

SELECT t1.*
FROM MyTable1 t1,
(
SELECT t2.ID
FROM MyTable2 t2, MyTable3 t3
WHERE t2.ID = t3.ID
) v1
WHERE t1.ID = v1.ID;

Now, I want to delete all the rows that have been selected. I know this works only in SQL Server but not ORACLE, but I am trying to give an idea of what I am trying to accomplish...

DELETE FROM t1
FROM MyTable1 t1,
(
SELECT t2.ID
FROM MyTable2 t2, MyTable3 t3
WHERE t2.ID = t3.ID
) v1
WHERE t1.ID = v1.ID;

Can anyone please tell me how to join a table and a view to delete matching rows from the table?

Your help is grately appreciated.

Regards,
Desi Rookie

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.