title: Linq to Entities - Subquery in the where statement
body: <p>This must be simple, but I've been searching for 2 hours, and can't find an answer. How do I write this in Linq to Entities:</p>
  
  <pre><code>SELECT Reg4, Reg5, Reg6
  FROM dbo.Table1
  WHERE Reg1 = 15
  AND Reg2 = ( SELECT MAX(Reg2) FROM dbo.Table2 WHERE Reg1 = 15);
  </code></pre>
  
  <p>Is it possible to do it both in query expressions and method based syntaxes? <br>
  Tks</p>