title: Creating a VIEW from multiple tables each with a different number of columns
body: <p>I want to combine multiple tables into one <code>VIEW</code>.<br>
  My understanding is that if the number of columns are different we cannot use <code>UNION</code>.<br>
  How do I solve this?</p>
  
  <p>I have the following three <code>TABLES</code>: </p>
  
  <p>1.<strong>Table Name- Albums</strong></p>
  
  <p><img src="https://i.stack.imgur.com/N0GzY.png" alt="enter image description here"></p>
  
  <p>2.<strong>Table Name-AlbumPictures</strong></p>
  
  <p><img src="https://i.stack.imgur.com/usmJl.png" alt="enter image description here"></p>
  
  <p>3.<strong>Table Name-Stories</strong></p>
  
  <p><img src="https://i.stack.imgur.com/JvwVU.png" alt="enter image description here"></p>
  
  <p>I want to have 3 tables as follows:(i can do this part using INNER JOINS- kindly correct me if i am wrong)</p>
  
  <p><strong>For Stories:</strong> StoryID,AlbumID,StoryTitle,AlbumCover,Votes</p>
  
  <p><strong>For Albums:</strong> AlbumID,AlbumName,AlbumCover,Votes</p>
  
  <p><strong>For Pictures:</strong> AlbumPictureID,Votes</p>
  
  <p>I want to merge all the rows retrieved from the above queries into one <code>VIEW</code>and shuffle them. As the number of columns are different in each of the result sets above am I able to combine them into one <code>VIEW</code>?</p>