Re: How to delete from one table based on a multiple table query

From: <CHUCK_HAMILTON_at_qvc.com>
Date: Fri, 12 May 2000 12:14:33 -0400
Message-Id: <10495.105528@fatcity.com>

You should be able to. Are you getting an error message or is it simply not deleting the rows you expect? Can you post the delete statement?
--

Chuck Hamilton
QVC Inc.
Enterprise Technical Services
Oracle DBA

                                                                                                                   
                    Christian                                                                                      
                    Carollo              To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    <CCarollo_at_viv        cc:     (bcc: CHUCK HAMILTON/QVC)                                         
                    a.com>               Subject:     How to delete from one table based on a multiple table query 
                    Ext: NA                                                                                        
                    Sent by:                                                                                       
                    root_at_fatcity.                                                                                  
                    com                                                                                            
                                                                                                                   
                                                                                                                   
                    05/12/00                                                                                       
                    11:17 AM                                                                                       
                    Please                                                                                         
                    respond to                                                                                     
                    ORACLE-L                                                                                       
                                                                                                                   
                                                                                                                   

I am trying to delete from a single table those records that match the results from a query joining several tables. This does not seem to work properly using a where exists statement. Does anyone have an alternative way of handling this?

Thanks,
Christian
--

Author: Christian Carollo
  INET: CCarollo_at_viva.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). Received on Fri May 12 2000 - 11:14:33 CDT