Conversion of Jet SQL Inner joins in UPDATES
I'm converting a Jet SQL system to Oracle, and I'm at a complete loss as to how to construct the following Jet
UPDATE.
UPDATE T1 INNER JOIN T2 ON (T1.A = T2.A) AND (T1.B = T2.B)
SET T1.ID = T2.ID
WHERE T1.ID IS NULL
This update is merely to fill in the link (ID's) in T1 from a matching records in T2 (A and B equivalent in both tables). While this may seem redundant, the situation is that T2 holds a master record and once T1 is linked to it, the values of T1.A and T.1B can subsequently change.
Thx