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