RE: Normalize DB record using SQL

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

Actually I didn't think that quite through.  This is better:

SELECT KEYA, KEYB, KEYC, 01 as MTHNBR, JANUARY FROM MYTABLE
UNION
SELECT KEYA, KEYB, KEYC, 02 as MTHNBR, FEBRUARY FROM MYTABLE
UNION
...

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"April 1. This is the day upon which we are reminded of what we are on the
other three hundred sixty-four."
        -- Mark Twain 


> > I have a file with fields for each month of the year, and would like
> to
> > create a view that would give me one record for each month using SQL.
> >
> >
> > Can someone give me an example of how to do this?