Nested SELECT clause in SQL Compact 3.5
- by Sasha
In this post "select with nested select" I read that SQL Compact 3.5 (SP1) support nested SELECT clause. But my request not work:
t1 - table 1
t2 - table 2
c1, c2 = columns
select
t1.c1,
t1.c2,
(select count(t2.c1) from t2 where t2.id = t1.id) as count_t
from
t1
Does SQL Compact 3.5 SP1 support nested SELECT clause in this case?
Update:
SQL Compact 3.5 SP1 work with this type of nested request:
SELECT ... from ... where .. IN (SELECT ...)
SELECT ... from (SELECT ...)
