Nested SELECT clause in SQL Compact 3.5
Posted
by Sasha
on Stack Overflow
See other posts from Stack Overflow
or by Sasha
Published on 2009-12-21T17:58:39Z
Indexed on
2010/05/16
1:00 UTC
Read the original article
Hit count: 446
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 ...)
© Stack Overflow or respective owner
