title: Select data from multiple tables even if there no data in one table
body: <p>I have 6 tables as follows,</p>
  
  <p>table-1,
  table-2,
  table-3,
  table-4,
  table-5,
  table-6</p>
  
  <p>All the tables have the same primary key.</p>
  
  <p>I want to create a view out of all these base tables. </p>
  
  <p>The where condition of the select query should qualify the primary keys of the first five tables.</p>
  
  <p>Requirement is this,</p>
  
  <p>1.The view should fetch the data from the first five tables plus the data in the sixth table.
  2.If there is no data in the 6th table, the view should still display the data in the 5 tables.</p>
  
  <p>I can qualify the primary keys of all the tables, but if i did then the view wont display any data 
  when there is no data in the 6th table and i dont want that.</p>
  
  <p>what do i do now?</p>