>
>
>MyNumericField MyMemoField
>
>1 Blah
>2 BlahBlah
>2 BlahBlah
>3 BlahBlahBlah
>
>I only want:
>
>1 Blah
>2 BlahBlah
>3 BlahBlahBlah
>
>But I can't group by a memo field, so how can I get this to work:
>
>SELECT MyNumericField, MyMemoField FROM MyTable INTO MyCursor
>
>
Raphael's reply to previous one would stand:)
Something like:
select distinct myNumericField from myTable into cursor crsTemp
select tmp.*,myMemoField ;
from myTable inner join crsTemp tmp on myTable.myNumericField = tmp.myNumericField ;
into cursor myCursor [readwrite]
Cetin