RE: SQL group totals

[rob@xxxxxxxxx]

I do not think your "count" implementation works.  COUNT seems to ignore 
what's in the parenthesis.

select co, cust, PO#, order#, pick#
from qtemp.craig 
1....+....2....+....3....+....4....+....5....+....6....+.
  CO            CUST   PO#         ORDER#           PICK#
 100             101   a1               1               1
 100             101   a1               1               2
 100             101   a1               1               3
 100             101   a1               2               4
 100             101   a1               2               5
 End of data  ******** 

select co, cust, PO#, count(order#) AS NbrOrders, count(pick#) as
nbrPicks 
from qtemp.craig 
group by co, cust, po# 
1....+....2....+....3....+....4....+....5....+....6....+..
  CO            CUST   PO#      NBRORDERS        NBRPICKS 
 100             101   a1               5               5 
 End of data  ******** 

Perhaps with some complicated mess involving DISTINCT or some such 
thing...

Rob Berendt