title: How can I run a query that is essentially only two left joins
body: <p>I have two tables and I would like to run a query that does something like this, where both columns can be null:</p>
  
  <pre><code>SELECT tableA.id as tableA, tableB.id as tableB
     LEFT JOIN tableA WHERE tableA.name LIKE 'blah%'
     LEFT JOIN tableB WHERE tableB.name LIKE 'blah%'
  </code></pre>
  
  <p>I know these queries aren't correct, but I'm trying to just convey the general idea of what I want.  What I am looking
  for is to be able to return the following result set</p>
  
  <pre><code>+------------+----+
  | tableA | tableB |
  +------------+----+
  |  NULL  |   1    |
  +------------+----+
  
  +------------+----+
  | tableA | tableB |
  +------------+----+
  |  NULL  |  NULL  |
  +------------+----+
  
  +------------+----+
  | tableA | tableB |
  +------------+----+
  | 1      |  1     |
  +------------+----+
  </code></pre>