title: Linq - Inner Join not retrieving all records from left table
body: <p>I have done an inner join, it shows only the matching record with following query :-</p>
  
  <pre><code>var data = from t1 in ctx.tblEmp
             join t2 in ctx.tblHelp 
                 on t1.Field equals t2.Fld
             where t1.Id == Id &amp;&amp; 
                   t2.Id == Id
             select new Settings { Master = t1.Labelname, OrderNo = t2.OrderNo};
  </code></pre>
  
  <p>I want all the records from <code>tblEmp</code> &amp; only matching records from <code>tblHelp</code>. </p>
  
  <p>How to do this?</p>