title: SqlCeCommand does NOT support subqueries?
body: <p>yesterday I wanted to create a sql query ( using system.data.sqlce ) which return values from diff tables on mobile devices.</p>
  
  <p>My scenario is as follows:
  - sql table: Xtable (fields: name : is string, mat :  is string, state : is int value);
  - XTable contains 100 records
  my sql statement is:</p>
  
  <pre><code>SELECT name, (SELECT count(*) from Xtable where state=0) as Marked, count(*) as Total
  FROM XTable
  GROUP BY name
  </code></pre>
  
  <p>result: 0 rows, because i have error with second SELECT.</p>
  
  <p>IF I execute following sql statement:</p>
  
  <pre><code>SELECT name, count(*) as Total FROM XTable GROUP BY name
  result : &gt; 0 rows.
  </code></pre>
  
  <p>Sqlcecommand not support multiselect query?
  how can I fix it ? </p>