Of course you can do this in Interbase. OTTOMH (I'm not at work right now):
update TABLE1 t1
set updatefield = ((
select t3.updatefield
from TABLE2 t2, TABLE3 t3
Where t1.idfield = t2.idfield
and t2.anotheridfield = t3.anotheridfield))
And you can add "where <t1 condition>" on the bottom if you need to. Note:
TWO pairs of parentheses. This is all documented in the Interbase Language
Reference guide. Look up the Update statement.
Cheers,
Carl
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
