title: Left Join without duplicate rows from left table
body: <p>Please look at the following query:</p>
  
  <p><strong>tbl_Contents</strong></p>
  
  <pre><code>Content_Id  Content_Title    Content_Text
  10002   New case Study   New case Study
  10003   New case Study   New case Study
  10004   New case Study   New case Study
  10005   New case Study   New case Study
  10006   New case Study   New case Study
  10007   New case Study   New case Study
  10008   New case Study   New case Study
  10009   New case Study   New case Study
  10010   SEO News Title   SEO News Text
  10011   SEO News Title   SEO News Text
  10012   Publish Contents SEO News Text
  </code></pre>
  
  <p><strong>tbl_Media</strong></p>
  
  <pre><code>Media_Id    Media_Title  Content_Id
  1000    New case Study   10012
  1001    SEO News Title   10010
  1002    SEO News Title   10011
  1003    Publish Contents 10012
  </code></pre>
  
  <p><strong>QUERY</strong></p>
  
  <pre><code>SELECT 
  C.Content_ID,
  C.Content_Title,
  M.Media_Id
  
  FROM tbl_Contents C
  LEFT JOIN tbl_Media M ON M.Content_Id = C.Content_Id 
  ORDER BY C.Content_DatePublished ASC
  </code></pre>
  
  <p><strong>RESULT</strong></p>
  
  <pre><code>10002   New case Study  2014-03-31 13:39:29.280 NULL
  10003   New case Study  2014-03-31 14:23:06.727 NULL
  10004   New case Study  2014-03-31 14:25:53.143 NULL
  10005   New case Study  2014-03-31 14:26:06.993 NULL
  10006   New case Study  2014-03-31 14:30:18.153 NULL
  10007   New case Study  2014-03-31 14:30:42.513 NULL
  10008   New case Study  2014-03-31 14:31:56.830 NULL
  10009   New case Study  2014-03-31 14:35:18.040 NULL
  10010   SEO News Title  2014-03-31 15:22:15.983 1001
  10011   SEO News Title  2014-03-31 15:22:30.333 1002
  10012   Publish         2014-03-31 15:25:11.753 1000
  10012   Publish         2014-03-31 15:25:11.753 1003
  </code></pre>
  
  <p><strong>10012 are coming twice...!</strong></p>
  
  <p>My query is returning duplicate rows from tbl_Contents (left table in the join)</p>
  
  <p>Some rows in tbl_Contents has more than 1 associated rows in tbl_Media.
  I need all rows from tbl_Contents even if there are Null values exists in the tbl_Media BUT NO DUPLICATE RECORDS.</p>