title: EntityFramework - LINQ Join help
body: <p>I have following schema:</p>
  
  <p><strong>Clients</strong> - ClientId
  <strong>Users</strong> - UserId
  <strong>Offices</strong> - OfficeId</p>
  
  <p><strong>ClientOffices</strong> - ClientId, OfficeId
  <strong>UserOffices</strong> - UserId, OfficeId</p>
  
  <p>Bold entities are EntityFramework Entities.</p>
  
  <p>Now I need to write a function which accepts UserId and returns a list of Clients - who also belong to the offices to which user belongs.</p>
  
  <p>E.g., Say ABC Inc. works with London Office, XYZ Inc. works with New York office.
  User "Yakoon" works only for Lond Office.</p>
  
  <p>The linq statement when executed should only return ABC Inc.
  If "Yakoon" belongs to New York office as well, then it should return btoh ABC and XYZ Inc.</p>
  
  <p>Thanks</p>