title: Combining the results of two SQL queries as separate columns
body: <p>I have two queries which return separate result sets, and the queries are returning the correct output.</p>
  
  <p>How can I combine these two queries into one so that I can get one single result set with each result in a separate column?</p>
  
  <p>Query 1:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT SUM(Fdays) AS fDaysSum From tblFieldDays WHERE tblFieldDays.NameCode=35 AND tblFieldDays.WeekEnding=?
  </code></pre>
  
  <p>Query 2:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT SUM(CHdays) AS hrsSum From tblChargeHours WHERE tblChargeHours.NameCode=35 AND tblChargeHours.WeekEnding=?
  </code></pre>
  
  <p>Thanks.</p>