Isn't this equivalent to?
update table1 set na1=
(select table2.na1 from table2 where
table1.no=table2.no);
Which can also be invalid if there can be
multiple rows returned by the subselect
since there'd be no way to know which
table2.na1 you'd want without more info.
On Fri, 2 Feb 2001, guard wrote:
> I not run update.... in Pgsql
>
> please tell me other method
> thanks
>
> ======================================
> update table1 a set na1=
> (select table2.na1 from table2,table1
> where table1.no=table2.no
> and a.no=table1.no);
>
>
>
>
