--- In ib-support@y..., Helen Borrie <helebor@t...> wrote:

> UPDATE TABLE1 SET FLAG = -1
> WHERE (EXISTS (SELECT RECNO FROM TEMP_TABLE))

Don't use this in SQL, though. If one record matches, all table1
records will be set to flag = -1 ;-)

Regards,
Andrew Ferguson
-- Infinity squared, and then some.