title: Nested SELECT clause in SQL Compact 3.5
body: <p>In this post "<a href="http://social.msdn.microsoft.com/Forums/en/sqlce/thread/ac926272-2382-4acb-84e3-fc32945c7cea" rel="nofollow noreferrer">select with nested select</a>" I read that SQL Compact 3.5 (SP1) support nested SELECT clause. But my request not work:</p>
  
  <p><em>t1 - table 1
  t2 - table 2
  c1, c2 = columns</em></p>
  
  <pre><code>select 
   t1.c1, 
   t1.c2, 
   (select count(t2.c1) from t2 where t2.id = t1.id) as count_t 
  from 
   t1 
  </code></pre>
  
  <p>Does SQL Compact 3.5 SP1 support nested SELECT clause in this case?</p>
  
  <p>Update:</p>
  
  <p>SQL Compact 3.5 SP1 work with this type of nested request:</p>
  
  <ul>
  <li>SELECT ... from ... where .. <strong>IN (SELECT</strong> ...)</li>
  <li>SELECT ... <strong>from (SELECT</strong> ...)</li>
  </ul>