Viewing 2 posts - 1 through 2 (of 2 total)
Having no concrete idea of what your table structure looks like...does this get close?
SELECT
DISTINCT e.empID, e
June 21, 2007 at 3:07 pm
#714463
You're probably getting "Distinct" combinations of your 3 select fields
If your data has 2 identical empID's with the same empName and CountyName, you'd get 1 row back
If your data has...
June 21, 2007 at 11:46 am
#714432