title: inner join two SELECT statements in ONE query AND show results from BOTH tables
body: <p>I want the use 2 SELECT statements and an INNER JOIN from different queries BUT also want to show the two different results, from different tables in the same query. Like this..</p>
  
  <pre><code>  SELECT column1 FROM earth e1 that is null
                       +
    SELECT chair5 FROM space s1 that is not null
  
    INNER JOIN space s1 ON e1.car = s1.truck
  
    ORDER BY e1.column,s1.chair5
  </code></pre>
  
  <p>How do I show the results of two different queries while using an INNER JOIN?</p>