>I am trying to select distinct records from a sql statement in vfp.
>But the distinct keyword only works on the whole record.
>My question is there a way to limit records by a distinct column in vfp6.0? Thanks Eric

SELECT field1, field2, field3
FROM MyTable
WHERE field1 in (SELECT DISTINCT field1 FROM MyTable)

BOb