Not Monitored
Tag not monitored by Microsoft.
42,119 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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'.
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.