title: Combine multiple results with conditions
body: <p>Suppose I have multiple queries:</p>
  
  <pre><code>SELECT col1, col2 FROM tab1 WHERE col1 = "%abc%";
  SELECT colA, colB FROM tab2 WHERE colA = "%123%" AND colB IS NOT NULL;
  SELECT colTest, colBlah FROM tab3;
  </code></pre>
  
  <p>Every query would return only 1 result.</p>
  
  <p>How can I combine those 3 results into 1?</p>
  
  <p>The result would look like that:</p>
  
  <pre><code>+------+------+------+------+---------+---------+
  | col1 | col2 | colA | colB | colTest | colBlah |
  +------+------+------+------+---------+---------+
  | abc  | def  | Ghi  | JkL  | 12A     | 42BD    |
  +------+------+------+------+---------+---------+
  </code></pre>
  
  <p>As <a href="https://stackoverflow.com/a/42349615/1170330">suggested here</a>, I could use a <code>cross join</code>. But where to put the <code>WHERE</code> conditions?<br>
  If I put them just at the end of the entire query, I would get an empty result, when only one of them fails. That's why I need to put them separately for every query.</p>