Re: SQL update question

Mike Ellenbecker wrote
>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;

sw_upload.fid is used out of scope. It is only known in the subquery:

    update sw_filemgm
    set sw_filemgm.longitude =

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

Arjan. Received on Tue Mar 09 1999 - 11:09:59 CST