New to SQL Server 2008 and setting up specific report

47 Views Asked by At

I am considerably new to the workings of SQL and I am stumbling my way through setting up reporting for some data.

Here is my code

SELECT [course_book no_],
       [customer no_],
       [not a licensed attorney],
       [book type code],
       [total cle credits]
FROM   pcam_data
WHERE  ( [posting date] BETWEEN '07/01/2014' AND '9/30/2014' )
       AND ( [entry no_] NOT IN (SELECT [applies to entry no_]
                                 FROM   pcam_data AS PCam_Data_1
                                 WHERE  ( [entry type] = 1 )) )
GROUP  BY [course_book no_],
          [customer no_],
          [not a licensed attorney],
          [book type code],
          [total cle credits] 

What I am looking to do is take the course numbers (column 1) and those that are alike (highlighted) part to be summed at the end of the report - Customer numbers do not need to be kept in that summation. Can I ask for some input or some guidance? I can provide an image of the output upon request.

0

There are 0 best solutions below