Where exists query syntax error?

2005-09-02 Thread Barbara Deaton
I need help re-writing a query. When accessing DB2 I can execute the below: delete from DM_KOHLS.clr_plan_price_change_metrics A where A.start_dt= Date( '05/15/2005' ) and

Re: Where exists query syntax error?

2005-09-02 Thread SGreen
Barbara Deaton [EMAIL PROTECTED] wrote on 09/02/2005 11:33:19 AM: I need help re-writing a query. When accessing DB2 I can execute the below: delete from DM_KOHLS.clr_plan_price_change_metrics A where A.start_dt= Date( '05/15/2005' ) and exists ( select *

RE: Where exists query syntax error?

2005-09-02 Thread Barbara Deaton
: Where exists query syntax error? Barbara Deaton [EMAIL PROTECTED] wrote on 09/02/2005 11:33:19 AM: I need help re-writing a query. When accessing DB2 I can execute the below: delete from DM_KOHLS.clr_plan_price_change_metrics A where A.start_dt= Date

RE: Where exists query syntax error?

2005-09-02 Thread SGreen
, 2005 11:48 AM To: Barbara Deaton Cc: mysql@lists.mysql.com Subject: Re: Where exists query syntax error? Barbara Deaton [EMAIL PROTECTED] wrote on 09/02/2005 11:33:19 AM: I need help re-writing a query. When accessing DB2 I can execute the below: delete from