SQL Compact 3.5中的嵌套SELECT子句 [英] Nested SELECT clause in SQL Compact 3.5

问题描述

在此帖子中，"选择带有嵌套的选择"，我读到SQL Compact 3.5(SP1)支持嵌套的SELECT子句.但是我的要求不起作用:

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-表1 t2-表2 c1，c2 =列

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 

在这种情况下，SQL Compact 3.5 SP1是否支持嵌套的SELECT子句?

Does SQL Compact 3.5 SP1 support nested SELECT clause in this case?

更新:

SQL Compact 3.5 SP1可以处理这种嵌套请求:

SQL Compact 3.5 SP1 work with this type of nested request:

• SELECT ... from ... from ... where .. IN(SELECT ...)
• 选择... 来自(选择 ...)

• SELECT ... from ... where .. IN (SELECT ...)
• SELECT ... from (SELECT ...)

推荐答案

感谢所有的帮助和建议.

Thank all for help and advise.

问题的最终答案-否. SQL Compact 3.5 SP1不支持嵌套的select子句.

这篇关于SQL Compact 3.5中的嵌套SELECT子句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！