title: Combine 2 select statements result sets
body: <p>Is there a way to combine the results from 2 select statements in sql? (like Union operator does - but Union works only for same number and type of columns)</p>
  
  <p>I want to do something like</p>
  
  <pre><code>SELECT * FROM JOBS j 
  UNION 
  SELECT COUNT(fj.Id_Filter) FROM JOBS j LEFT JOIN FILTER_JOBS fj ON j.Id=fj.Id_Job
  </code></pre>
  
  <p>but it doesn't work with UNION</p>