pgsql关联两张表update数据

update t20 set cno=(select "编码" from t19 where t20.std_no=t19."标准码");