Re: [SQL] How to delete multiple records

2006-09-14 Thread Reinoud van Leeuwen
On Thu, Sep 14, 2006 at 03:07:35PM +0900, Javanesevn wrote: > Dear all, > > I execute this query on below: > > delete from PRODUCT > where exists ( > select > product_id, item_id > from PRODUCT > where >research_date < '2006-

Re: [SQL] How to delete multiple records

2006-09-14 Thread Markus Schaber
Hi, Javanesevn, Javanesevn wrote: > I execute this query on below: > > delete from PRODUCT > where exists ( > select > product_id, item_id > from PRODUCT > where >research_date < '2006-01-01' > ) > this query deleted all

[SQL] How to delete multiple records

2006-09-13 Thread Javanesevn
Dear all, I execute this query on below: delete from PRODUCT where exists ( select product_id, item_id from PRODUCT where research_date < '2006-01-01' ) this query deleted all records data in PRODUCT table. The subquery