Re: Update 1 table based on 2 other tables

Hi Dan,
I rewrote the SQL to be:

UPDATE T1
SET T1.DATE_RESOLVED = SYSDATE
WHERE T1.T1_ID IN (SELECT T1B.T1_ID
FROM T1B,
T2,
T3
WHERE T1B.DATE_R IS NULL
AND T1B.T2_ID = T2.T2_ID
AND T2.T3_ID = T3.T3_ID
AND (SYSDATE - T3.R_DAYS) > T1B.DATE_P); COMMIT; Thanks.
PS So you're a Washington Husky married to a UConn Husky? ;-) Received on Fri Jan 28 2005 - 08:39:37 CST