Re: SQL Update
______________________________ Reply Separator _________________________________
Subject: SQL Update
Author: bkersey@wolsi.com at INTERNET
Date: 9/3/97 6:18 AM
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)
Try: UPDATE holstk
SET holstk.namt = (SELECT stock.c_prc FROM stock
WHERE stock.pc = holstk.pc) ## returned stock.c_prc
## must be unique.
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