I not run update.... in Pgsql
please tell me other methodthanks
======================================update table1 a set na1=(select table2.na1 from table2,table1where table1.no=table2.noand a.no=table1.no);