Re: Update 1 table based on 2 other tables

UConnFan92 wrote:

> 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? ;-)

With every joke imaginable delivered numerous times. ;-)

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)