update cpu_bid_notice.cpu_bid_pjt_notice
set cpu_bid_notice.cpu_bid_pjt_notice.consignor_enterprise_name
=
( select consignor_org_name from cpu_bid_project.cpu_bid_project
where cpu_bid_notice.cpu_bid_pjt_notice.bill_id =cpu_bid_project.cpu_bid_project.id)