You can always convert a nested query into an equivalent join.
您始终可以将嵌套查询转换成等价的连接。
The structure of SQL-like nested queries is examined. It is shown that any SQL- like nested query can be decomposed into four basic nested types.
本文分析了SQL类查询语句的基本结构，指出任何一个嵌套结构的SQL类语句都可以由四种基本嵌套类型组成。
You can drill down multiple levels in a query to specify nested predicates, clauses, and expressions.
您可以在一个查询中钻取多层，以指定嵌套的谓词、子句和表达式。
The nested loop join method is used to join the remote query result from each warehouse and the XML composite view result.
这里使用了嵌套的循环连接方法来连接来自每个仓库的远程查询结果和xml合成视图结果。
Join plan directives that force optimizer to use the designated join method to join tables in the query, either nested loop join, sort merge join, or dynamic hash join.
连接计划指示，强制优化器使用指定的连接方法来连接查询中的表，要么是嵌套循环连接、分类合并连接，要么是动态哈希连接。
Figure 4 shows a plan using the nested loop join operations at the federated server to evaluate this query.
图4展示了一个在联邦服务器使用嵌套循环连接操作符来计算这个查询的计划。
Can these operators be nested in parenthesis and mixed with the other query language operators?
这些操作符会被嵌套在括号中并与其他的查询语言操作符混合在一起吗？
It also requires a query language to provide constructors that are capable of creating complex nested structures on the fly — a facility that is not needed in a relational language.
这也需要一种查询语言来提供可动态创建复杂嵌套结构的构造函数，而该工具在关系语言中是不需要的。
In order to execute this report with no error, Dynamic Query Mode requires levels nested in the same order as specified by the hierarchy on a single edge.
为了正确执行这个报告，DynamicQueryMode要求按照层次结构规定的顺序在单个边上嵌套层级。
In order to execute this report with no error, Dynamic Query Mode requires levels nested in the same order as specified by the hierarchy.
为了正确执行这个报告，DynamicQueryMode要求根据层次结构规定的顺序嵌套级别。
In order to execute this report with no error, the Dynamic Query Mode requires levels nested in the same order as specified by the hierarchy on a single edge.
为了不出错地执行该报表，DynamicQueryMode要求根据等级结构指定的顺序在单一边缘嵌套级别。
Example 5: INLIST to Nested Loop Join (query rewrite).
例子5：INLIST改为嵌套循环连接(查询重写)。
You can populate every elements array with a separate SQL query, thus allowing for SQL result sets to be nested to an unlimited depth.
您可以使用单独的SQL查询填充每个elements数组，从而允许SQL结果集被嵌入到无限制的深度。
When this report is executed in either query mode, the report displays the Sales regions and country nested as the rows and the Quantity measure as the columns.
以任一查询模式执行这个报告时，报告都显示Salesregions和Country嵌套为行，Quantit y度量值数据嵌套为列。
If the query includes a join, the optimizer must determine the join plan (hash, sort merge, or nested loop), and the order in which tables are evaluated or joined.
如果该查询包含了连接，那么优化器就必须确定连接计划(hash、sortmerge或nestedloop)，以及评估或连接表的次序。
In order to solve the difficulty of nested structure of SQL, the idea of query block is introduced and the algorithm of changing query block to SQL is realized.
为了解决嵌套结构转换的难点，引进了查询块的概念，实现了查询块向SQL语句转换的算法，并将此转换方法与以前的方法进行了比较。
The first of which is to just use a nested SQL query every time the records tables are updated.
第一种是只使用一个嵌套的SQL查询每一个时间记录表更新。
In this paper, a relational database based on nested relation is proposed it supports text storage and text operator. The text query is supported by signature file indexing technology.
本文提出的一个嵌套关系模型支持文本存储和文本检索操作，其中特征文件索引为文本检索提供了技术支持。
In this paper, a relational database based on nested relation is proposed it supports text storage and text operator. The text query is supported by signature file indexing technology.
本文提出的一个嵌套关系模型支持文本存储和文本检索操作，其中特征文件索引为文本检索提供了技术支持。
应用推荐