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-
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
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