title: Display all data from one table regardless info from second table
body: <p>Ineed to display <code>ALL info from T1 and T2 where T1.Catalogue = T2.Catalogue</code></p>
  
  <p>The tables are NOT equal, meaning T2 not necessarily has info for each row of T1, but I need BOTH TABLES to be displayed anyway.</p>
  
  <p>How do I do this please?</p>
  
  <p>This will not produce what I want: </p>
  
  <pre><code>select master.*, digital_info.* from master 
  INNER JOIN digital_info on master.Catalogue = digital_info.Catalogue; 
  </code></pre>
  
  <p>neither will LEFT JOIN produce:</p>
  
  <pre><code>select master.*, digital_info.* 
  from master 
  LEFT JOIN digital_info 
  on master.Catalogue = digital_info.Catalogue;
  </code></pre>
  
  <p>[[[ sorry perhaps my question was rather confusing... i've amended it ]]]</p>