Thanks,
Shoaib
On 12/8/06,
Alban Hertroys <alban@xxxxxxxxxxxxxxxxx> wrote:
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 //
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
