DISTINCT

[Brad Bross]

Could someone help me include a DISTINCT statement so I do not get duplicates
on the "SMTkey" field? Thx.

SELECT CIMOR_dwvStandardMeansTest.ConsumerKey,
CIMOR_dwvStandardMeansTest.ResponsibilityStartDate,
CIMOR_dwvStandardMeansTest.SMTkey
FROM CIMOR_dwvStandardMeansTest
WHERE (((CIMOR_dwvStandardMeansTest.ConsumerKey)=749649 Or
(CIMOR_dwvStandardMeansTest.ConsumerKey)=376406 Or
(CIMOR_dwvStandardMeansTest.ConsumerKey)=16578));

 

[Marshall Barton]

Could someone help me include a DISTINCT statement so I do not get duplicates
on the "SMTkey" field? Thx.

SELECT CIMOR_dwvStandardMeansTest.ConsumerKey,
CIMOR_dwvStandardMeansTest.ResponsibilityStartDate,
CIMOR_dwvStandardMeansTest.SMTkey
FROM CIMOR_dwvStandardMeansTest
WHERE (((CIMOR_dwvStandardMeansTest.ConsumerKey)=749649 Or
(CIMOR_dwvStandardMeansTest.ConsumerKey)=376406 Or
(CIMOR_dwvStandardMeansTest.ConsumerKey)=16578));

SELECT DISTINCT ConsumerKey,
ResponsibilityStartDate,
SMTkey
FROM CIMOR_dwvStandardMeansTest
WHERE ConsumerKey IN(749649,376406,16578)

 

[Jerry Whittle]

If you want only a unique SMTkey value to show up in each record, you'll have
to do something like below. You'll need to decide which ConsumerKey and
ResponsibilityStartDate records you want returned using functions like Max,
Min, First, Last, etc.

SELECT C.SMTkey,
Max(C.ConsumerKey),
Max(C.ResponsibilityStartDate)
FROM CIMOR_dwvStandardMeansTest as C
WHERE C.ConsumerKey= IN (749649, 376406, 16578)
GROUP BY C.SMTkey ;

 

[Tyro]

Excellent advice. Thx.