merge into 范例

MERGE INTO sfea_t a

USING (SELECT sfebent

,sfebsite

,sfebdocno

,sfea002

-- ,sfea003

FROM sfeb_t

,sfea_t

WHERE sfeaent = sfebent

AND sfeasite = sfebsite

AND sfeadocno = sfebdocno

AND sfea003 = '010700003'

AND sfea002 = '0002611'

AND sfeb013 = 'C901121'

AND sfebent = 901

AND sfebsite = '010706') b

ON (a.sfeaent = b.sfebent AND a.sfeasite = b.sfebsite AND a.sfeadocno = b.sfebdocno AND a.sfea002 = b.sfea002 /*AND a.sfea003 = b.sfea003*/

)

WHEN MATCHED THEN

UPDATE

SET a.sfea003 = '1073002003'