title: Greater Than Condition in Linq Join
body: <p>I had tried to join two table conditionally but it is giving me syntax error. I tried to find solution in the net but i cannot find how to do conditional join with condition. The only other alternative is to get the value first from one table and make a query again.</p>
  
  <p>I just want to confirm if there is any other way to do conditional join with linq.</p>
  
  <p>Here is my code, I am trying to find all position that is equal or lower than me. Basically I want to get my peers and subordinates.</p>
  
  <pre><code>from e in entity.M_Employee
  join p in entity.M_Position on e.PostionId &gt;= p.PositionId
  select p;
  </code></pre>