Mike Yearwood
Toronto, Ontario, Canada
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only