query error

Question

when i try run next query give me error

query

UPDATE dbo.SUB_VOUCHER SET ORA_DATE=(SELECT ORA_DATE FROM VOUCHER

WHERE SUB_VOUCHER.ENTRY_SERIAL=VOUCHER.ENTRY_SERIAL

error

Msg 102, Level 15, State 1, Line 2

Incorrect syntax near 'ENTRY_SERIAL'.

Answer 1

Try to add “)”:

UPDATE dbo.SUB_VOUCHER 
SET ORA_DATE=(SELECT ORA_DATE FROM VOUCHER
              WHERE SUB_VOUCHER.ENTRY_SERIAL=VOUCHER.ENTRY_SERIAL)

Probably you can also rewrite the statement using a JOIN.