与mysql大略不同，postgreSQL查询时更新用如下方式：
UPDATE tb1SET c1=b.c1 ,c2=b.c2FROM bWHERE tb1.c3 = b.c3 AND tb1.c4 = b.c4