Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL update question

Re: SQL update question

From: <andrewf_at_jaredgroup.com>
Date: Tue, 09 Mar 1999 17:18:35 GMT
Message-ID: <7c3l50$lon$1@nnrp1.dejanews.com>


Should be

update sw_filemgm

set sw_filemgm.longitude = (select sw_upload.longitude
                              from sw_upload
                             where sw_filemgm.fid = sw_upload.fid);

In article <7c38v4$3e55_at_musky.state.wi.us>,   "Mike Ellenbecker" <ellenm_at_mail01.dnr.state.wi.us> wrote:
> what wrong with this SQL statement?
>
> table to update sw_filemgm
> table updating from sw_upload
> unquie id to both tables FID
>
> 1 update sw_filemgm
> 2 set sw_filemgm.longitude = (select sw_upload.longitude
> 3 from sw_upload)
> 4 where sw_filemgm.fid = sw_upload.fid;
>
> ERROR at line 4:
> ORA-00904: invalid column name
>
> the column names are correct.
>
> Thanks in Advance
>
> Mike Ellenbecker
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 09 1999 - 11:18:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US