Subject Re: [firebird-support] Updates with select XXX from TABLE
Author Martijn Tonies
Hello Jan,

> Is it possible to use more difficult updates by FB?
> Something like:
> update TABLE1 set from TABLE2 where id in (1,2,3);
> I mean useing selects in updates and inserts..

Well, yes you can use SELECTs, but that's not what you're
doing :-)

update table1
set id = (select id from table2 where id in (1, 2, 3) )

Do note that you're updating all "id"s in Table1.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions