title: MySQL : Returning empty field instead of no row
body: <p>I have two tables, one for English category names, and another for Spanish category names. </p>
  
  <p>I am attempting to write a small interface which allows an admin to see for which English categories a translation must still be provided. </p>
  
  <p>I will write it assuming that when you create a Spanish category, it inherits the ID of the English category.</p>
  
  <p>To get a results set of corresponding categories, I have this query:</p>
  
  <pre><code>SELECT tbl_cms_categories_en.id as id, 
     tbl_cms_categories_en.name as en, 
     tbl_cms_categories_es.name as es 
  FROM   tbl_cms_categories_en, tbl_cms_categories_es 
  WHERE  tbl_cms_categories_en.id = tbl_cms_categories_es.id
  </code></pre>
  
  <p>This returns a nice list of entries:</p>
  
  <p><img src="https://i.stack.imgur.com/gcqWC.png" alt="enter image description here"></p>
  
  <p>This serves my purpose well, but there is one deficiency. If there is no row in the Spanish table, it does not return a derived row at all.</p>
  
  <p>How could I change my query so that, if there is a row in the English table but not the Spanish one, I could return the derived row to say "No translation found".</p>
  
  <p>Akin to:</p>
  
  <pre><code>ID = 8, en = "Security", es = "Translation Not Found"
  </code></pre>
  
  <p>Any guidance would be bigly appreciated.</p>
  
  <p>Thanks dudes!</p>