Table update on joined tables
Date: 21 Mar 2003 13:12:25 -0800
Message-ID: <b0f265c8.0303211312.482568c_at_posting.google.com>
I come from a SQL Server background, but we are converting to Oracle
[8.1.7] on HP-UX.
How would I translate the following update:
to a query that Oracle 8.1.7 can recognize???
UPDATE M
SET M.PROPERTY_ID = R.RESORT,
M.REDEEM_DATE = R.REDEEM_DATE,
M.REDEEM_USER = R.REDEEM_USER,
M.VOUCHER_STATUS = 'REDEEMED',
M.UPDATE_DATE = R.UPDATE_DATE,
M.UPDATE_USER = R.UPDATE_AGENT
FROM AWARD A,
TYPE T,
REDEMPTION R,
MW_REDEMPTION M
WHERE A.TYPE_ID = T.TYPE_ID
AND A.AWARD_ID = R.AWARD_ID
AND A.SERIAL_1 = M.VOUCHER_ID
AND A.SERIAL_2 = M.VOUCHER_SERIAL
AND M.VOUCHER_STATUS = 'ISSUED';