Duplicates Query

S

shamrox

Joined
Dec 14, 2007
Messages
2
Reaction score
0
I have 5 Fields: If the ParentLink Field has dups plus ANY one of the other 3 fields have dups, I want to pull it, within a date range.
1) InvalidRouting
2) InvalidAcct
3) InvalidTypeSent
4) ParentLink
5) Date

Can anyone see what I am doing wrong? It's not working at all. It's not giving error, it just doesn't show the dups and I can see them in the table when I search for them manually. SQL below:

SELECT dbo_DDReturns.InvalidRouting, dbo_DDReturns.InvalidAcct, dbo_DDReturns.InvalidTypeSent, dbo_DDReturns.ParentLink, dbo_DDReturns.Date
FROM dbo_DDReturns
WHERE (((dbo_DDReturns.InvalidRouting) In (SELECT [InvalidRouting] FROM [dbo_DDReturns] As Tmp GROUP BY [InvalidRouting],[InvalidAcct],[InvalidTypeSent],[ParentLink] HAVING Count(*)>1 And [InvalidAcct] = [dbo_DDReturns].[InvalidAcct] And [InvalidTypeSent] = [dbo_DDReturns].[InvalidTypeSent] And [ParentLink] = [dbo_DDReturns].[ParentLink])) AND ((dbo_DDReturns.Date) Between [Start Date] And [End Date]))
ORDER BY dbo_DDReturns.InvalidRouting, dbo_DDReturns.InvalidAcct, dbo_DDReturns.InvalidTypeSent, dbo_DDReturns.ParentLink;

Thanks in advance! Shamrox
 
Back
Top