ScrmingWhisprs
I <3 Coffee Milk.
- Local time
- Yesterday, 22:55
- Joined
- Jun 29, 2006
- Messages
- 156
Hi,
I have the following duplicate check query that is returning inaccurate results:
Below are the results and the two rows that I have marked for some reason are being displayed...
I have the following duplicate check query that is returning inaccurate results:
Code:
SELECT *
FROM tblListDetails
WHERE (((tblListDetails.record_id) In (SELECT [record_id] FROM [tblListDetails] As Tmp GROUP BY [record_id] HAVING Count(*)>1 )) AND ((tblListDetails.list_id)=24));
Below are the results and the two rows that I have marked for some reason are being displayed...
Code:
id list_id record_id
2123 24 6374
2124 24 6374
2125 24 44 <------
2126 24 6664 <------
2128 24 5958
2129 24 5958
2130 24 6926
2131 24 6926
2133 24 6667
2134 24 6667
2135 24 6373
2136 24 6373
Last edited: