Query Question -- Query Using Monthly Data

From: Smitty <marksmithy69_at_hotmail.com>
Date: Tue, 25 Sep 2007 08:49:40 -0700
Message-ID: <1190735380.143373.35000@19g2000hsx.googlegroups.com>

Hello everyone. I currently have a simple table, DAILY, containing various daily transactions. The table has a date column, transaction 1, transaction2, transaction3 etc. Example:

DATE       Transaction1       Transaction2     Transaction3
1-1-2007      5                         3                  1
1-13-2007     3                        7                  9
1-17-2007     6                        2                  4
2-3-2007      5                         3                  1
3-10-2007     5                        3                  1

I need to grab the data from the DAILY table, and insert the sum of all transactions for each month into a MONTHLY table, so I will have:

DATE       Transaction1       Transaction2     Transaction3
2007-01      14                         12                 14
2007-02       5                           3                  1
2007-03       5                           3                  1

I am very new to SQL, so I am not sure if this is simple or not. Thanks very much in advance. Received on Tue Sep 25 2007 - 10:49:40 CDT