Reply to thread

Message: [QUOTE="slotmgr70, post: 13558575"] Hate to be a pest, but I'm still getting duplicate records for some players. It seems as if the query is creating "ghost" records. For example, I have two records for a player that only had one transaction. The "adjusted by" and "comment" fields are different for the two records, but the other fields are identical. Here is the SQL script once again: SELECT DISTINCT dbo_PBT_PROMO_ADJUSTMENT.AdjustmentDate, dbo_PBT_PROMO_ADJUSTMENT.Player_ID, [dbo_CDS_PLAYER.lastname] & ", " & [dbo_CDS_PLAYER.firstname] AS [Player Name], [dbo_CDS_USER.lastname] & " ," & [dbo_CDS_USER.firstname] AS [Adjusted by], Sum(dbo_PBT_PROMO_ADJUSTMENT.Amount) AS SumOfAmount, Trim(Right([COMMENTS],Len([COMMENTS])-InStrRev([COMMENTS],","))) AS ACTUAL_COMMENTS FROM ((((dbo_CDS_AUDITDETAIL INNER JOIN dbo_CDS_AUDITTRAIL ON dbo_CDS_AUDITDETAIL.AuditTrail_ID = dbo_CDS_AUDITTRAIL.AuditTrail_ID) INNER JOIN dbo_CDS_USER ON dbo_CDS_AUDITTRAIL.User_ID = dbo_CDS_USER.User_ID) INNER JOIN dbo_CDS_AUDITOBJECT ON dbo_CDS_AUDITTRAIL.AuditTrail_ID = dbo_CDS_AUDITOBJECT.AuditTrail_ID) INNER JOIN dbo_CDS_PLAYER ON dbo_CDS_AUDITOBJECT.Meta_ID = dbo_CDS_PLAYER.Player_ID) INNER JOIN dbo_PBT_PROMO_ADJUSTMENT ON dbo_CDS_PLAYER.Player_ID = dbo_PBT_PROMO_ADJUSTMENT.Player_ID WHERE (((dbo_CDS_AUDITTRAIL.AuditEvent_ID)=2630)) GROUP BY dbo_PBT_PROMO_ADJUSTMENT.AdjustmentDate, dbo_PBT_PROMO_ADJUSTMENT.Player_ID, [dbo_CDS_PLAYER.lastname] & ", " & [dbo_CDS_PLAYER.firstname], [dbo_CDS_USER.lastname] & " ," & [dbo_CDS_USER.firstname], Trim(Right([COMMENTS],Len([COMMENTS])-InStrRev([COMMENTS],","))) HAVING (((dbo_PBT_PROMO_ADJUSTMENT.AdjustmentDate) Between #9/13/2009# And #9/14/2009#)); Thanks, [/QUOTE]

Verification