Re: SQL Update

Dear BKersey, Try (select stock.c_prc from stock where (some condition to return exactly one row). The update reference stock.c_prc is not tied in anyway to the select sub-query in the where clause. Not a very informative error message! HTH, Jason On Tue, 02 Sep 1997 21:51:30 -0600, bkersey@wolsi.com wrote: >Can someone please tell me what is wrong with this: >update holstk >set holstk.namt = (stock.c_prc) >where holstk.pc in >(select stock.namt > from stock > where stock.pc=holstk.pc) > >The reported error is: > Table does not exists > Table: stock > >Well Stock sure does as this work : >Select stock.pc, holstk.pc >from stock, holstk >where stock.pc=holstk.pc> >Thanks in advance >BKersey > >-------------------==== Posted via Deja News ====----------------------- > http://www.dejanews.com/ Search, Read, Post to Usenet