<http://schema.org/articleBody>
"It appears that UPDATE/DELETE cannot be used with CTE (WITH ...) due to obstinateness. Too bad. I apologize for the misstep. Anyway, maybe this will serve you better: (3 statements instead of two.) You'll note a lot of re-use here. CREATE TABLE QTEMP/SHPCONPO AS ( SELECT SHIPPER, CONSIGNEE, PO, WAVE, COUNT(*) as COUNTER , MIN(RRN(PROBLEMTBL)) as RRNBR FROM PROBLEMTBL GROUP BY SHIPPER, CONSIGNEE, PO HAVING COUNT(*) &amp;gt; 1 ) WITH DATA UPDATE PROBLEMTBL PT SET WAVE = 'MULTI' WHERE EXISTS (SELECT 1 FROM QTEMP/SHPC..."^^<http://www.w3.org/2001/XMLSchema#string>
<http://archive.midrange.com/midrange-l/201210/msg00149.html>