Add an index on DELETED() on all tables involved in the query. Make it a binary index if you are using VFP9.

>Naomi, I've tried the following:
>
>

>SELECT Ordsize.orderprodid,;
>  SUM(Ordsize.ordered) AS totordered,;
>  SUM(Ordsize.allocated) AS totallocated,;
>  SUM(Ordsize.shipped) AS totshipped;
> FROM ordsize ;
> GROUP BY ordsize.orderprodid
>
>

>
>The SYS(3054,11) Result is:
>Rushmore... NONE
>
>Then I tried, as per your suggestion:
>

>SELECT Ordprod.orderid, Ordsize.orderprodid,;
>  SUM(Ordsize.ordered) AS totordered,;
>  SUM(Ordsize.allocated) AS totallocated,;
>  SUM(Ordsize.shipped) AS totshipped;
> FROM ;
>     Ordsize ;
>    INNER JOIN ordprod ;
>   ON  Ordprod.orderprodid = Ordsize.orderprodid ;
> GROUP BY Ordsize.orderprodid, Ordprod.orderid
>

>
>Again the SYS(3054,11) Result is:
>NONE for both tables.
>
>Any more ideas,
>Mike