( SELECT StaffContractPhone + ','
FROM dbo.details_StaffDiscount SD
WHERE SD.SaleRecordCode = s.SaleRecordCode
ORDER BY SD.SaleRecordCode
FOR
XML PATH('')
) StaffContractPhone ,--员工联系电话
FROM dbo.details_StaffDiscount SD
WHERE SD.SaleRecordCode = s.SaleRecordCode
ORDER BY SD.SaleRecordCode
FOR
XML PATH('')
) StaffContractPhone ,--员工联系电话