>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
Forget about DISTINCT,
use GROUP BY intead...
:-)
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca