>I have a table contains a project code, job code and quantity. I need to generate a result set that will show, uniquely, job codes that are used in any project and the total quantity of that job code across all projects. i.e.
>
>projectcode jobcode quantity
>AAAAAAAA A1 5
>BBBBBBBB A1 4
>CCCCCCCC A1 1
>
>This would generate a result set of: A1 10
>
>Any suggestions greatly appreciated.
Hi Colin,

Use:

SELECT jobcode, SUM(quantity);
  FROM whatevertable;
  GROUP BY jobcode;
  INTO CURSOR foo

hth,