title: sql join query to linq syntax
body: <p>how do i change this to linq to sql?</p>
  
  <pre><code>select * from ratesSchedule as rs
      inner join userdetails as ud on rs.sid = ud.sid
      and rs.tabletype = 'd'
  </code></pre>
  
  <p>i got this far</p>
  
  <pre><code>var results = from rs in db.ratesSchedule
                join ud in db.userdetails on rs.sid equals ud.sid
  </code></pre>
  
  <p>but i can't figure out how to add the "and rs.tabletype='d'"</p>