>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
If you remove the GROUP BY, does the missing item show up?
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.