title: UNION syntax in Cakephp
body: <p>Anyone knows a good way to make UNION query in CakePHP? I would like to avoid using <code>$this-&gt;query();</code>.</p>
  
  <p>With two tables t1, t2:</p>
  
  <pre><code>SELECT * FROM t1
  LEFT JOIN t2 ON t1.id = t2.id
  UNION
  SELECT * FROM t1
  RIGHT JOIN t2 ON t1.id = t2.id
  </code></pre>
  
  <p>With three tables t1, t2, t3:</p>
  
  <pre><code>SELECT * FROM t1
  LEFT JOIN t2 ON t1.id = t2.id
  LEFT JOIN t3 ON t2.id = t3.id
  UNION
  SELECT * FROM t1
  RIGHT JOIN t2 ON t1.id = t2.id
  LEFT JOIN t3 ON t2.id = t3.id
  UNION
  SELECT * FROM t1
  RIGHT JOIN t2 ON t1.id = t2.id
  RIGHT JOIN t3 ON t2.id = t3.id
  </code></pre>