Your posted code is missing an { before the year 1997.

>I am getting a "GROUP BY clause is missing or invalid" when I run the query above. Im not sure if I should be using DISTINCT or GROUP BY.
>I want to show unique rows for csono
>
>
>SELECT sosOrd.csono,dcreate,cItemno,cwarehouse ;
>FROM sosord INNER JOIN sostrs ON sosord.cSoNO=sostrs.cSoNo WHERE dcreate>1997/01/01} GROUP BY sosord.csono INTO CURSOR tempcurs
>
>Carmel