DB2 Update Query Problem

[DBLearner]

Consider two tables T1 and T2. T1 has two columns F1 and F2. T2 has two columns F3 and F4. We need to set F1 = F3 where F2 = F4. A query for this made for ORACLE works, but does not work under DB2. What will be the DB2 specific implementation of this query? (and the standard SQL92 implementation?.

[Kschuler]

Are you looking for the SQL update statement? Show us the Oracle version you have and we can try to help you convert it. It should work the same in DB2, there just might be some syntax differences.