Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL update question
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