PDA

View Full Version : Select Distinct


aargus07
04-02-2009, 12:21 AM
I have created a command to do this before but darn
if I can remember how I did it and cannot see it defined
this way in the help section.

1) Table with say 10 fields.
2) Some records have identical company names
3) I want to select ALL fields from each record, but
only 1 occurrence of each company name into cursor Y

SELECT DISTINCT coname FROM x INTO CURSOR Y WHERE ?????

Or something similar

Thanks,

Dan