Sorry it should have been as follows
Im still get the same error though and Im not sure whether I should be using DISTINCT or GROUP BY to find unique csono rows


SELECT sosord.csono,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