Re: Query Question -- Query Using Monthly Data

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.

Your design is the worst possible in a relational database and violates the rules of normalization.

A well designed table would look like this:

DATE      TRANSACTION#    VALUE
2007-01         1           14
2007-01         2           12
2007-01         3           14
2007-02         1            5
2007-02         2            3
2007-02         3            1
2007-03         1            5
2007-03         2            3
2007-03         3            1

With a proper design you should find writing queries far easier.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org