title: Oracle/SQL - Combining counts from 'unrelated' unrelated tables
body: <p>Let's assume I two tables <code>GOOD</code> and <code>BAD</code> that stores records for widget production.  My tables look like this</p>
  
  <pre><code>Widget      Good
  ----------------
  Widget A    Y
  Widget A    Y
  Widget B    Y
  
  Widget      Bad
  ----------------
  Widget A    Y
  Widget B    Y
  </code></pre>
  
  <p>I have these two basic queries</p>
  
  <pre><code>select count(*) as good from table_good where widget = 'Widget A' and Good = 'Y'
  select count(*) as bad from table_bad where widget = 'Widget A' and Bad = 'Y'
  </code></pre>
  
  <p>These would result in two tables like this</p>
  
  <pre><code>good
  ----
  2
  
  bad
  ---
  1
  </code></pre>
  
  <p>I would like to combine these into a single query where I would get back a table with a single record that looks like this</p>
  
  <pre><code>good    bad
  -----------
  2       1
  </code></pre>
  
  <p>Can someone point me how to do this.  I thought doing a union and setting up fake columns in the other tables selects would do it, but I got the right table schema back, but had two seperate records.</p>
  
  <p>Thanks!</p>