HELP WITH QUERY SELECTION

[Jlok]

I am using a query to retrieve data from a btrieve dbase. The table I'm using has multiple lines of the same entry. How would I select just the first one?

Example:
1
1
1
1
1
2
2
2
2
I need to just get the first first entry of all the different entrys.. 1,2 and so on

 

[THoey]

Did you try using the DISTINCT clause? Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...