SELECT UID, dd
FROM (SELECT UID, COUNT(UID) AS dd
FROM dbo.CN_Infomation
GROUP BY UID) DERIVEDTBL
WHERE (dd > 1)
SELECT *
FROM Members
WHERE (Member_ID IN
((SELECT Member_ID
FROM (SELECT Member_ID, COUNT(Member_ID) AS dd
FROM dbo.Members
GROUP BY Member_ID) DERIVEDTBL
WHERE (dd > 1))))
ORDER BY Member_ID DESC