- 该项目用于拉取洪波数据并且进行相关的数据合并
- 通过宏波管点管线 更新成果表中的数据
- update tf_ywpn_pspipe_w a set a.hb_id =(select hb_id from tf_hb_pipe b
- where ( b.work_area = a.DESIGN_GONGHAO and a.in_juneid = b.start_bsm and a.out_juneid = b.end_bsm ) )
- update tf_ywpn_psnode_w a set hb_id=(select hb_id from tf_hb_node b where a.design_gonghao = b.work_area and a.pipe_id = b.cad_code )
|