If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Update with select

B is my target table.A is source table.I have to select rows in source table which got updated and the same rows in target which has to be updated.
I am doing that using select clause

SELECT
A.DM_LINEAGE_ID
FROM
CO c,
LINEAGE A
WHERE
A.PROCESS_NM = 'SP'
AND NOT EXISTS ( SELECT
A.DM_LINEAGE_ID
FROM
CON_DIM CON_DIM,
LINEAGE A
WHERE
C.COUNTRY_CD=CON_DIM.COUNTRY_CD AND
CON_DIM.COUNTRY_NM= C.COUNTRY_NM
AND A.PROCESS_NM ='SP'))
Now,I have an audit table which has an id value.I have to update the target table with the id value....