Question

sql server中用left join 连接多张表，出现重复数据，如何去掉重复数据？

SELECT a.bizArea,c.tranOutDate,a.cntNo,b.custName,d.productname,d.matSpec,d.amountReal,d.unitPrice,a.cntType,d.amountMoney
FROM crm_deliver c
left join crm_deliverDetail d on c.deliverNo=d.deliverID
left join crm_contractbaseinfo a on c.crtNO=a.cntNo
left join crm_termianlcustbaseinfo b on a.cntCustomerNo=b.custNo
WHERE c.tranOutDate BETWEEN '2014-3-1' and '2014-4-15'

Answer 1

你的d表,a表和b表的关联字段在做join之前要保证唯一性..

比如
left join (select distinct bizArea,cntNo from crm_contractbaseinfo) a on c.crtNO=a.cntNo