RE: Bad SQL.....

Remember - Drink responsibly - Kidding.

Raj.

-----Original Message-----
From: Farnsworth, Dave [SMTP:DFarnsworth_at_Ashleyfurniture.com] Sent: Friday, May 25, 2001 3:26 PM

To:     Multiple recipients of list ORACLE-L
Subject:        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).

NetZero Platinum
No Banner Ads and Unlimited Access
Sign Up Today - Only $9.95 per month!
http://www.netzero.net
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rajaram
  INET: rajaram_k_at_netzero.net

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).