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.