I am thinking about converting a Decision Support
database from MySQL. The UPDATE statement in MySQL
doesn't support updating the values in one table using
values or criteria from multiple tables. Thus, my
question: Does Interbase support the updating of
values in one table based upon criteria or data in
other tables?

An example of what I'm looking for follows:

update table1
set table1.column1 = table2.column3
from table1, table2
where table1.column2 = table2.column2;

Thanks,

Andrew Gould

__________________________________________________
Do You Yahoo!?
Thousands of Stores. Millions of Products. All in one Place.
http://shopping.yahoo.com/