Re: How to use outer join in update

On fös, 2006-12-08 at 10:09 +0100, Alban Hertroys 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

is this not effectively an INNER JOIN ?
the OP needed a LEFT JOIN.

gnari