PDA

View Full Version : Select Distinct


aargus07
04-01-2009, 11:21 PM
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