title: Intersecting with LINQ on single column
body: <p>I have 2 queries.</p>
  
  <pre><code>var suppliers = 
      from u in db.Users
      join s in db.Suppliers
      on u.SupplierID equals s.supplierID
      select u;
  
  var AreaServiced = 
      from a in db.Areas_Serviceds
      where a.Area.AreaName == AreasServiced
      where a.Area.State == StateServiced
      select a;
  </code></pre>
  
  <p>and I want to to intersect them to get all the supplier details. So they would just be intersecting on supplierID.</p>
  
  <p>I cant use suppliers = suppliers.intersect(AreaServiced)</p>
  
  <p>because suppliers and areasserviced do not have the same columns. </p>
  
  <p>I currently dont have it in a single statemnet because I dont ALWAYS want htem to intersect (if the user doesnt care about area serviced then i will jsut display the suppleirs without caring where they service)</p>
  
  <p>so later on i can do something like If (!customerCaresAboutAreaServiced) { intersect two tables }</p>
  
  <p>otherwsie i would ignore second table.</p>