pg库将A表中某一列值更新未B表中某一列

update QDWB set qqmc = (select xzqmc from T_XZQMC where QDWB.QQBM= T_XZQMC.XZQDM);