title: Using UNION ALL with INNER JOIN
body: <p>I have 3 tables. I have unified two of them using <code>UNION ALL</code>, but I cannot unify the third because there is only one field in common <code>"receipt"</code>. </p>
  
  <p>I want to get a output like: </p>
  
  <p><code>costumerid/ amount  / receipt / saledate /cost</code></p>
  
  <p><strong>My code right now is:</strong></p>
  
  <pre><code>SELECT t1.costumerid, t1.amount, t1.receipt, t1.saledate
  FROM t1
  WHERE t1.amount&gt;'100' AND t1.saledate&lt;Date()-180 
  UNION ALL
  SELECT t2.costumerid, t2.amount, t2.receipt, t2.saledate
  FROM t2
  WHERE t2.amount&gt;'100' AND t2.saledate&lt;Date()-180 
  </code></pre>
  
  <p>Any help?  Thanks in advance!</p>