title: SQL join tables show empty field if record doesn't exist
body: <p>I'm in need of help.</p>
  
  <p>I need to join two doubles</p>
  
  <p>Table 1</p>
  
  <pre><code>Product_Name Content_Type Price
   Movie         Adult       10
   Movie         Kids        10
  </code></pre>
  
  <p>Table 2</p>
  
  <pre><code>Product_Name Content_Type Rating
   Movie         Adult        A
   Movie         Kids         B
   Movie         Romance      C
  </code></pre>
  
  <p>I need to join the tables so that it looks like this</p>
  
  <p>Desired Output</p>
  
  <pre><code> Product_Name Content_Type Price Rating
     Movie         Adult      10     A
     Movie         Kids       10     B
     Movie         Romance           C   
  </code></pre>
  
  <p>Current Output</p>
  
  <pre><code> Product_Name Content_Type Price Rating
     Movie         Adult      10     A
     Movie         Kids       10     B
     Movie         Romance    10     C 
  </code></pre>
  
  <p>Current Query</p>
  
  <pre><code>select * from table2 left join table1 on table2.Product_Name=table1.Product_Name 
  </code></pre>
  
  <p>In actual fact, in the real table there are many values for Product_Name.
  I wrote the query like that with this logic in mind,</p>
  
  <p>Look for all rows in table2, find a match in table1 and join the rows. If there is a row in table2, but no row in table1, then only show table2's value while showing Null for the corresponding fields in table1.</p>