Seems you do not care what are other field values. Then try:
sele * from... GROUP by myPrimaryKey


>Hi - is there a way to select all the fields in a table with an SQL SELECT command checking one field as DISTINCT... a bit like this but this doesn't work...
>
>SELECT * DISTINCT myPrimaryKey FROM myTable INTO CURSOR myCursor
>
>Any ideas?
>
>Thanks