At 11:57 AM 07-05-02 +0000, you wrote:

>Hi,
>
>I'm using values in a temporary table as a means to select rows from
>a main table, as in the example below:
>
>update Table1 set Flag = -1 where RecNumber in
>(select RecNo from Temp_Table)

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

-- H

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________