Complex update query

[kalindi05]

Hello everyone,

Please help me revise this query to make it work. I don't know much about update query so I will need some help with it. Thanks,


update encounter
set mergedpayment = totalactualcash payments
from encounter E, paymentITEM P, encounterfinanc ialrecord F
where (E.encounterid = P.FINANCIALRECN UM) AND (E.encounterid = F.FINANCIALRECN UM) and (transtypecode = 'C') and (F.INSPLANCODE not in ('UNINSURED', 'SP', 'Selfpay'));

[saravanankm]

hi kalindi05!

Pls Check Update Statement Correct.

format is

Update our_table set
Column_name = Value
where Condition ;

Qry Error

Thanks
Captain

[godskyller]

try something like this

update TABLE_X A
set A.TX_PASS = (
SELECT B.TX_PASS
FROM TABLE_Y B
WHERE A.CD_USER = B.CD_USER
)