> ... is there a way to update quantity and cost fields in incumbents
> with the matching records from candidates? It seems that UPDATE is
> designed only to update one record at a time...
Oh, no, it is certainly possible to do what you want here. The usual trick is:
UPDATE sometable set somefield=somevalue where id in (select id from somecomplicatedsubquery)
Maximilian Tyrtania Software-Entwicklung
Dessauer Str. 6-7
10969 Berlin
http://www.contactking.de