Subject Newbie : Update with select statement
Author Jenny Sigvardsdotter
Hi!
First I would like to say thanks to the replies I got
to my other questions. You helped me a lot.

I have a statment with an update. If I would write it
in T-sql I could use

UPDATE aktkonto
set batchid=:new_batchid,
from akt
where akt.aktid = aktkonto.aktid
and aktkonto.batchcode = 1
and akt.EBV = 1

But this is not acceptable in IB.
I use Interbase 5.6 How can I get the same
functionality?

Thanks
//Jenny



__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com