title: How do I take the results of multiple selects and combine into one row
body: <p>I have a table that contains information for 4 electrical generators. I would like to have the results of the four querys in one row. Does any one have a suggestion?</p>
  
  <pre><code>SELECT  avg(KW) as GEN_101_AVG
  FROM         genset WHERE     (GenSetName   like 'GEA3519') and GenDate &gt;= '1 jan   2003    00:00:00' and GenDate &lt; '1 feb 2003 00:00:00'
  
     SELECT  avg(KW) as GEN_201_AVG
  FROM         genset WHERE     (GenSetName   like 'GEA3520') and GenDate &gt;= '1 jan 2003 00:00:00' and GenDate &lt; '1 feb 2003 00:00:00'
  
  SELECT  avg(KW) as GEN_301_AVG
  FROM         genset WHERE     (GenSetName   like 'GEA3521') and GenDate &gt;= '1 jan 2003 00:00:00' and GenDate &lt; '1 feb 2003 00:00:00'
  
  SELECT  avg(KW) as GEN_401_AVG
  FROM         genset WHERE     (GenSetName   like 'GEA3522') and GenDate &gt;= '1 jan 2003 00:00:00' and GenDate &lt; '1 feb 2003 00:00:00'
  </code></pre>