title: How to join 3 tables and order by date of all 3?
body: <p>I have 3 tables,</p>
  
  <p>albums, videos and stories.</p>
  
  <p>All 3 have a date column and each connected with subject_id column.</p>
  
  <p>I want to select all albums, videos and stories of subject_id ordered by date, How can i do that?</p>
  
  <p>Now i have this query :</p>
  
  <pre><code>SELECT albums.*, videos.*, stories.*
  FROM albums
  LEFT JOIN videos
  ON videos.subject_id = albums.subject_id
  RIGHT JOIN stories
  ON stories.subject_id = albums.subject_id
  ORDER BY albums.date
  </code></pre>
  
  <p>Will this do the trick or am i missing something?
  Because i want the dates not be ordered just by albums, stories could have older enteries then albums and so on.</p>