[SQL] how to simulate UPdate ...?

[guard]

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);