SQL - Deleteing rows from a table-- Help!!!

I need to delete certain rows from a Table. To delete the rows I need to join to another table which contains the rows I need to delete. It is based upon the following SQL select:

select *
from accts t1, dup_accts t2
where t1.acct_id=t2.acct_id and

           t1.cust_id=t2.cust_id;

I need to delete all the rows from the accts table which match to this join. I am really confused!!!!
Can anyone help!!!!!!

Shaun de Souza
mailto:shaun.desouza_at_cibc.com
Phone: 416.780.3295
Fax: 416.784.7581 Received on Wed May 31 2000 - 08:09:30 CDT