title: C# lambda expression question - how to join 2 tables using Lambda statements from the following SQL?
body: <p>I have 2 tables, and I would like to join them using Lambda statements (not Linq but Lambda).</p>
  
  <p>This is the query that I need:</p>
  
  <pre><code>SELECT
      c.*
  FROM
      board as b
  LEFT JOIN category as c ON
      b.cid = c.cid
  WHERE
      b.bid = 1
  </code></pre>
  
  <p>How do I do this?</p>
  
  <p>Say if <strong>board</strong> is a dataset/variable and <strong>category</strong> is an other dataset/variable then i want somethign like
  board.Join(category).Where(b=>b.bid==c.cid) ( i know this is wrong but just so you have an idea what i am looking for thank you so much for all your help</p>