Do you have an index on ordsize.orderprodid?

>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.