title: JOIN / UNION SELECT all rows from two tables with different number of columns
body: <p>I am trying to join or union the results of two differently structured tables, order them by a their common pubdate column, but get an error message:</p>
  <blockquote>
  <p>The used SELECT statements have a different number of columns</p>
  </blockquote>
  <pre><code>SELECT * FROM news WHERE published='1' AND image!='' AND featured='1'
  JOIN
  SELECT * FROM videos WHERE published='1'
  ORDER BY pubdate DESC
  </code></pre>
  <p>How can I edit my query so that I can run my fetch array and retrieve the corresponding rows afterwards (the rows to be fetched is then decided on another common row that both tables share)?</p>