说明:关联t_device与t_dict表更新t_channel表
update t_channel cne set parent_name = v_parent_name,
camera_type_name=v_camera_type_name from (
select d1.*,d2.device_name v_parent_name, d3.label v_camera_type_name
from t_channel d1
left join t_device d2 on d1.parent_id = d2.id
left join t_dict d3 on d3.key='cameraType' and d3.value = d1.camera_type
) cne2 where cne.id=cne2.id