** 表bsvc_order_tel与表bsvc_order_details关联字段为order_id,要将bsvc_order_details中的org_id字段的内容更新到bsvc_order_tel表中的org_id字段**
update bsvc_order_tel set org_id = orgId from (
select details.org_id as orgId ,
details.order_id as orderId
from bsvc_order_tel tel join bsvc_order_details details on tel.order_id = details.order_id
) A
where order_id = A.orderId