title: Left join on Linq?
body: <p>I'm actually not sure if this is exactly a left join; I'm not an expert on SQL. I have the following Linq query:</p>
  
  <pre><code>        var title = dataSet.Tables["title"].AsEnumerable();
          var author = dataSet.Tables["author"].AsEnumerable();
          var review = dataSet.Tables["review"].AsEnumerable();
  
          var results = from t in title
                        join a in author on t["Url"] equals a["Url"]
                        join r in review on t["Url"] equals r["Url"]
                        select new { 
                            tText = t["InnerText"], 
                            aText = a["InnerText"], 
                            rText = r["InnerText"] 
                        };
  </code></pre>
  
  <p>My problem is that sometimes there is no matching review on the "review" column, but I still want to get the title and the author on my result. How can I achieve this?</p>