Andrus wrote: > In my current DBMS I can use > > create table t1 ( f1 int, f2 int ); > create table t2 ( f3 int, f4 int ); > update t1 set f1=t2.f3 from t1 left join t2 on t1.f2=t2.f4 That looks like a self-join on t1 without using an alias for the second instance of t1. I think you meant: update t1 set f1=t2.f3 from t2 where f2 = t2.f4 -- Alban Hertroys alban@xxxxxxxxxxxxxxxxx magproductions b.v. T: ++31(0)534346874 F: ++31(0)534346876 M: I: www.magproductions.nl A: Postbus 416 7500 AK Enschede // Integrate Your World //
