update ${JDE_SCHEMA}.F4102 set ibstkt = 'M'
WHERE ibstkt = 'P'
and exists (SELECT 'X'
FROM proddta.F4111
WHERE ilmcu = ibmcu
AND ilitm = ibitm
AND ildct = 'IC');
WHERE ibstkt = 'P'
and exists (SELECT 'X'
FROM proddta.F4111
WHERE ilmcu = ibmcu
AND ilitm = ibitm
AND ildct = 'IC');
No comments:
Post a Comment