In this related question "http://social.msdn.microsoft.com/Forums/en/sqlce/thread/ac926272-2382-4acb-84e3-fc32945c7cea " I read that SQL Compact 3.5 (SP1) support nested SELECT clause. But my request not work. I have got an error : "There was an error parsing the query. [ Token line number = X,Token line offset = XX,Token in error = select ] "
t1 - table 1; t2 - table 2; c1, c2 = columns;
(select count (t2.c1) from t2 where t2.id = t1.id) as count_t
Does SQL Compact 3.5 SP1 support nested SELECT clause in this case?
View Complete Post