Re: Query Question -- Query Using Monthly Data

"Jerome Vitalis" <vitalismanN05P4M@xxxxxxxxxxxxxxxxx> wrote in message
news:46f93913$0$9091$79c14f64@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Tue, 25 Sep 2007 08:49:40 -0700, Smitty wrote:

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.

Post your try first. And explain exactly how many columns there are in
your tables.

Take a look at the GROUP BY clause in a SELECT statement. You'll also need
to use a TO_CHAR() function with the proper format string to get just a
year-month.

--
Terry Dykstra


.