Re: Update 1 table based on 2 other tables

UConnFan92 wrote:

> UPDATE T1
> SET T1.DATE_R = SYSDATE
> WHERE T1.DATE_R IS NULL
> AND T1.T2_ID IN ( SELECT T2.T2_ID
> FROM T2,
> T3
> WHERE T2.T3_ID = T3.T3_ID
> AND T3.CAN = 'N'
> AND T1.DATE_P < (SYSDATE - T3.R_DAYS);
> COMMIT;
>
> These two SQL statements works fine when executed.
> When I try to place them into a procedure, I get an error that says
> R_DAYS is not a valid column in table T3.
> HELP!
> Thanks

Is it? Do a describe. Look at your syntax. How many left parentheses? How many right?

And before anyone jumps on this answer ... this is school work and I am intentionally giving a few hints but not the answer.

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