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