UPDATE dbo.FC_CUSTOMER SET SECTION_CODE= A.SECTION_CODE
FROM FC_CUSTOMER C
LEFT JOIN
(
SELECT CUSTOMER_CODE,SECT.SECTION_CODE FROM dbo.FC_CUSTOMER CUST
JOIN FC_SALESMAN SL ON SL.SALESMAN_CODE=CUST.SALESMAN_CODE
JOIN FC_SECTION SECT ON SECT.SECTION_CODE=SL.SECTION_CODE
) A
ON A.CUSTOMER_CODE = C.CUSTOMER_CODE
UPDATE FROM SELECT.txt
最新推荐文章于 2024-01-14 14:53:36 发布