SQL update question

From: Mike Ellenbecker <ellenm_at_mail01.dnr.state.wi.us>
Date: Tue, 9 Mar 1999 07:45:42 -0600
Message-ID: <7c38v4$3e55@musky.state.wi.us>

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 Received on Tue Mar 09 1999 - 07:45:42 CST