注意
1 主表不能起别名
2 主表和从表的关联字段不能同名
UPDATE b_5_r set geom = b_5_r1.geom1 from b_5_r1
– LEFT JOIN b_5_r1 on b_5_r.o_number = b_5_r1.o_number
WHERE o_number = b_5_r1.o_number1 and b_5_r.o_floor in (3,4,5,6,7,8)
05-20
07-26
1862
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
08-12
1206
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)