pl1101
Programmer
- Dec 5, 2009
- 46
- 0
- 0
Hello, I have need help in modifying an update statement. I am bringing back a number of rows with my sql, but when I add the update piece it updates less rows.
-- update APPLICATION
--set PRIMARY_PARAM ='Something Special' (800 rows)
where app_id in
(select A.app_id (820 Rows)
from APPLICATION A
inner join CBT_CPNT_MOD B
on A.APP_ID = B.APP_ID
inner join PA_CPNT C
on B.CPNT_ID = C.CPNT_ID
and B.CPNT_TYP_ID = C.CPNT_TYP_ID
and B.REV_DTE = C.REV_DTE
where C.DMN_ID = '001'
and SUBSTR(A.PRIMARY_PARAM, 1, 14) = ' ;
What would cause the difference in rows and how can I fix this?
Please help!
-- update APPLICATION
--set PRIMARY_PARAM ='Something Special' (800 rows)
where app_id in
(select A.app_id (820 Rows)
from APPLICATION A
inner join CBT_CPNT_MOD B
on A.APP_ID = B.APP_ID
inner join PA_CPNT C
on B.CPNT_ID = C.CPNT_ID
and B.CPNT_TYP_ID = C.CPNT_TYP_ID
and B.REV_DTE = C.REV_DTE
where C.DMN_ID = '001'
and SUBSTR(A.PRIMARY_PARAM, 1, 14) = ' ;
What would cause the difference in rows and how can I fix this?
Please help!
