RE: Bad SQL.....

Thank you very much. I was thinking that I needed to do a nested select. It worked great. I'll have a beer for you after I leave work! :)

Dave

-----Original Message-----
Sent: Friday, May 25, 2001 1:46 PM
To: Multiple recipients of list ORACLE-L

I think it's just Friday. You need to rewrite your statement to read something like this:

UPDATE AVAILABLE_POWER SET available_power_driver_terminated = 'Y' where available_power.driver_id in (select manpowerprofile.mpp_id from manpowerprofile where manpowerprofile.mpp_terminationdt <> to_date('31-DEC-2049','DD-MON-RRRR') )

At 09:01 AM 5/25/01 -0800, you wrote:
>I am trying to write an update statement but seem to be having problems.
>Below is my statement and the error in SQL*Plus.
>
>
> 1 UPDATE AVAILABLE_POWER SET available_power.driver_terminated = 'Y'
> 2 WHERE available_power.driver_id = manpowerprofile.mpp_id
> 3* and manpowerprofile.mpp_terminationdt <>
>TO_DATE('31-DEC-2049','DD-MON-YYYY')
>SQL> /
> and manpowerprofile.mpp_terminationdt <>
>TO_DATE('31-DEC-2049','DD-MON-YYYY')
> *
>ERROR at line 3:
>ORA-00904: invalid column name
>
>
>I know that manpowerprofile.mpp_terminationdt is a valid table column. Do
I
>need to do some type of join on these two tables? Or is it just Friday and
>I should give up and go have a cold beer!!:o) Any advice would be
>appreciated.
>
>Thanks,
>
>Dave
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Farnsworth, Dave
> INET: DFarnsworth_at_Ashleyfurniture.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Regina Harter
  INET: rharter_at_emc-inc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  INET: DFarnsworth_at_Ashleyfurniture.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).