This statement is represented in the example as subquery S1.
这个语句在示例中表示为子查询s1。
You cannot define a foreign key constraint in a CREATE TABLE statement that contains an AS subquery clause.
你不能在CREATETABLE语句中包含AS子查询子句定义一个外键约束。
In the example, this is represented by the outermost select statement, which USES S1 as a subquery.
在这个示例中,这由最外层的选择语句表示,这个语句将S1用作子查询。
As of this writing, YQL doesn't allow you to link tables through common keys (a join), but only permits you to use the results of one query inside another (a subquery).
在撰写本文时,YQL还不允许您通过公用键(一个联接)来链接表,只允许您在一个查询(一个子查询)内使用另一个查询的结果。
The SHIP3 operator contains the statement that shows the result of the scalar subquery being bound in as a host variable.
SHIP3操作符包含一个语句,该语句表明标量子查询的结果放在一个主机变量中。
A scalar subquery is an embedded query that returns a single row that contains a single column — essentially, a single value, which is known as a scalar.
标量子查询是一种嵌入式查询,返回包含单个列的单个行,本质上就是单个值,该值称为标量。
Why is the result column of a subquery not using my alias as the column name?
为什么一个查询不使用我的别名为列名的结果列?
Why is the result column of a subquery not using my alias as the column name?
为什么一个查询不使用我的别名为列名的结果列?
应用推荐