title: LINQ Lambda Left join with an Inner join
body: <p>I have written a LINQ lambda query which so far which returns all staff which do not have an associated training row which works fine. I now need to amend my where clause to use the manager id joining manager table onto staff. </p>
  
  <p>I am a little unsure how to modify this left join lambda to include an inner join. If anyone can point me in the right direction that would be very much appreciated.</p>
  
  <pre><code>    var managerId = 1;
  
      var query = db.staff
  
                  .GroupJoin(db.training,
                      s =&gt; s.id,
  
                      t =&gt; t.staff_id,
                      (s, t) =&gt; new {Staff = s, Training = t.FirstOrDefault()})
  
      //TODO: join manager.id on staff.manager_id
  
  
              .Where(st =&gt; st.Training==null);//TODO: modify where clause &amp;&amp; manager.id == managerId 
  </code></pre>
  
  <p>Thanks</p>