Hello there, probably not the right place to put this question but I didn`t know were else to put it.
I`m trying to insert data into a temporary table from more than one select statement.
So I have 4 fields which can hold a month as a 3 character entry and another 4 fields which hold values for that month.
I want to get all the months together to view the data for a month, so the select statements might return this data:
Area month1 val1 month2 val2 month3 val3 month4 val4
a JUN 10 JUL 5 AUG 15 SEP 11
b MAY 6 JUN 10 JUL 10 AUG 15
I want to find out the data for the areas for the month of JUN and I was thinking of loading the data into a temporary table but how do I insert data from more than one select?
The first area goes in fine with insert # but how would I insert other data?