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 * from SESSION.delete_table_tmp B
where A.clr_plan_sk = B.clr_plan_sk)
I modified it to be what I thought was a valid MySQL statement but when I
execute it against MySQL I get a syntax error:
ERROR: Execute error: You have an error in your SQL syntax. Check the manual
that corresponds
to your MySQL server version for the right syntax to use near 'exists (
select * from
delete_table_tmp where clr_plan_price_ch
The statement I executed is:
delete from clr_plan_price_change_metrics
where start_dt>= '2005-05-15' and
exists ( select * from delete_table_tmp
where clr_plan_price_change_metrics.clr_plan_sk =
delete_table_tmp.clr_plan_sk)
I can successfully execute each piece of the query, but when I combine it with
the 'exists' subquery it fails.
The examples in the doc show just selects... Exists() so I tried changing it to
a select from table and still fails. What is the correct syntax?
-Barb.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
