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

To make it easy consider this.........

	select * from accts where acct_id in 


	(select acct_id from dup_accts) and cust_id in

	(select cust_id from dup_accts);

Hope this helps!

take care,
Christine Turner
DBA
IPS Sendero
Scottsdale, Arizona

From: 	DeSouza, Shaun[SMTP:Shaun.DeSouza_at_CIBC.com]
Reply To: 	ORACLE-L_at_fatcity.com
Sent: 	Wednesday, May 31, 2000 7:39 AM
To: 	Multiple recipients of list ORACLE-L
Subject: 	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

-- 
Author: DeSouza, Shaun
  INET: Shaun.DeSouza_at_CIBC.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).