<p>Hello there, probably not the right place to put this question but I didn`t know were else to put it.</p>
<p> </p>
<p>I`m trying to insert data into a temporary table from more than one select statement.</p>
<p>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.</p>
<p>I want to get all the months together to view the data for a month, so the select statements might return this data:</p>
<p> </p>
<p>Area month1 val1 month2 val2 month3 val3 month4 val4</p>
<p> a JUN 10 JUL 5 AUG 15 SEP 11</p>
<p> b MAY 6 JUN 10 JUL 10 AUG 15</p>
<p> </p>
<p>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?</p>
<p>The first area goes in fine with insert # but how would I insert other data?</p>
