Message-Id: <10495.105543@fatcity.com> From: "Steve Boyd" Date: Fri, 12 May 2000 17:57:40 GMT Subject: Re: How to delete from one table based on a multiple table query And I suppose you would write it something like: DELETE FROM TABLE1, TABLE2 WHERE TABLE1.FLD1 = TABLE2.FLD2; You can't do that in Oracle. >From: "Atish Prasad Das" >Reply-To: ORACLE-L@fatcity.com >To: Multiple recipients of list ORACLE-L >Subject: Re: How to delete from one table based on a multiple table query >Date: Fri, 12 May 2000 08:48:55 -0800 > >i can't see a reason, why can't u do that using a straight forward delete > where stmt!!! > >----- Original Message ----- >To: Multiple recipients of list ORACLE-L >Sent: Friday, May 12, 2000 8:47 PM > > > > 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@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@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). > > > >-- >Author: Atish Prasad Das > INET: atish.das@wipro.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@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). ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com