I have tested your suggestion of spaces before the semi-colons. No such luck.

SQL is:

SELECT pricelist.ITEM, pricelist.REPL, pricelist.price, pricelist.DATE ;
FROM price!pricelist ;
ORDER BY pricelist.DATE DESC ;
GROUP BY pricelist.ITEM ;
INTO TABLE temp.DBF

I am looking to have one record per item number, but to also have the latest price release date possible of the item out of this table. This is why I have used the order by date code. The table contains about 10 price list releases (10 of the same part number).

Jeff


>>I have the following SQL statement:
>>
>>SELECT pricelist.ITEM, pricelist.REPL, pricelist.price, pricelist.DATE;
>>FROM price!pricelist;
>>GROUP BY pricelist.ITEM;
>>INTO TABLE temp.DBF
>>
>>The results do not show an item number:
>>
>>T97000-503
>>
>>but it will show an item number:
>>
>>T97000-503R
>>
>>What may I be doing wrong?
>
>What kind of results are you looking for? Usually you don't group unless you are using aggregate funcitons like SUM() or AVG() or COUNT().
>
>Also, I have had trouble with continued selects when I didn't put a space prior to the semi-colon.
>
>SELECT * ;
>FROM thistable ;
>where this=that
>
>BOb