I'm not 100% sure of what you are asking but believe that you are looking for the Group By Rollup clause to achieve this.
Thanks, Matthew Stokes Software Engineer Internet Technologies IBM Server Group Certified: RHCE, MCSE,CLPD(R5), IBM Specialist help I have twelve columns that I need to SUM, no problem. Within an SQL I now want to take all the SUM's and sum them. I can not find an example of this in our shop and would appreciate any help. thank you. David K. Johnson CGI MVS Application Support E-mail: [EMAIL PROTECTED] Phone(direct line): 905-282-4229 Extension: 150 - 4229 Page: 416-372-9838 Floor 5th, 2920 Matheson Blvd East Mississauga, ON L4W 5J4 ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
