如何去掉这里的重复数据呢?急急~~~~~
SELECT Charge_Temp.CopyDate, Charge_Temp.UserID, Charge_Temp.Name, [Users]![Area] & [Users]![Road] & [Users]![Address] AS Addr, [ChargeMeters]![CurNum]-[ChargeMeters]![PreNum] AS SumDegree, ChargeMeters.Money, Charge_Temp.OtherFee, Charge_Temp.SumFee, Charge_Q.IfPay, Charge_Q.IfPrint, Charge_Q.IfNote, Charge_Q.PayDate, Charge_Q.Operator
FROM (ChargeMeters INNER JOIN Meters ON ChargeMeters.MeterID = Meters.MeterID) INNER JOIN ((Charge_Temp INNER JOIN Charge_Q ON (Charge_Temp.CopyDate = Charge_Q.CopyDate) AND (Charge_Temp.UserID = Charge_Q.UserID)) INNER JOIN Users ON Charge_Temp.UserID = Users.UserID) ON (ChargeMeters.CopyDate = Charge_Temp.CopyDate) AND (Meters.UserID = Charge_Temp.UserID);
上面的查询语句显示的数据如下,我使用的是查询视图,这里出现了好几个是重复的,应该如何去掉呢?去掉的结果在也在下面。请高手们赐教!!!
CopyDateUserIDNameAddrSumDegreeMoneyOtherFeeSumFee
IfPayIfPrintIfNotePayDateOperator
2007-4U_001001鼓楼区同安路01125.691260204NoNoNo
2007-4U_001001鼓楼区同安路0144.94450204NoNoNo
2007-4U_001001鼓楼区同安路0132.69330204NoNoNo
2007-4U_001001鼓楼区同安路01125.691260204NoNoNo
2007-4U_001001鼓楼区同安路0144.94450204NoNoNo
2007-4U_001001鼓楼区同安路0132.69330204NoNoNo
2007-4U_001001鼓楼区同安路01125.691260204NoNoNo
2007-4U_001001鼓楼区同安路0144.94450204NoNoNo
2007-4U_001001鼓楼区同安路0132.69330204NoNoNo
2007-4U_002002台江区禾祥西路02119.761200389NoNoNo
2007-4U_002002台江区禾祥西路02268.62690389NoNoNo
2007-4U_002002台江区禾祥西路02119.761200389NoNoNo
2007-4U_002002台江区禾祥西路02268.62690389NoNoNo
2007-4U_003003台江区禾祥东路03126.671270127NoNoNo
2007-4U_004004鼓楼区禾祥东路fasdfasd108.971090232NoNoNo
2007-4U_004004鼓楼区禾祥东路fasdfasd122.571230232NoNoNo
2007-4U_004004鼓楼区禾祥东路fasdfasd108.971090232NoNoNo
2007-4U_004004鼓楼区禾祥东路fasdfasd122.571230232NoNoNo
去掉重复的结果如下:
CopyDateUserIDNameAddrSumDegreeMoneyOtherFeeSumFeeIfPayIfPrintIfNotePayDateOperator
2007-4U_001001鼓楼区同安路01125.691260204NoNoNo
2007-4U_001001鼓楼区同安路0144.94450204NoNoNo
2007-4U_001001鼓楼区同安路0132.69330204NoNoNo
2007-4U_002002台江区禾祥西路02119.761200389NoNoNo
2007-4U_002002台江区禾祥西路02268.62690389NoNoNo
2007-4U_003003台江区禾祥东路03126.671270127NoNoNo
2007-4U_004004鼓楼区禾祥东路fasdfasd108.971090232NoNoNo
2007-4U_004004鼓楼区禾祥东路fasdfasd122.571230232NoNoNo
[解决办法]
select distinct……