The on clause condition is applied entirely at the join level.
on子句条件完全在联接级别应用。
The join condition is the on clause filter specified in the merge statement.
在merge语句的on子句中指定了联接条件。
The filters in the on clause can contain complex queries or simple expressions.
on 子句中的过滤器能够包含复杂查询或者简单表达式。
If there are no foreign keys, it does not generate an ON clause and the tables become a cross product.
如果没有外键，则不生成ON子句，表将变成矢量积。
We have held talks with them, and with a sell-on clause inserted in the deal we are not far off agreement.
我们已经和俱乐部谈过了，在转会中加入了一条出售附加条款，现在离达成协议已经不远了。
For each record in the EMP_PHOTO table, the condition in the on clause is checked to find a matching EMPLOYEE record.
对于EMP _ photo表中的每条记录，都要检查on子句中的条件，以发现匹配的EMPLOYEE记录。
Note that the storage clause must precede the HASH ON clause, which is not clear from the syntax diagrams in the manual.
注意存储子句必须在HASHon子句之前，在手册页语法图解中这一点不是很明确。
Conceptually, the merge function joins source table rows with target table rows by applying the on clause filter. All the joined rows are updated or deleted on the target.
从概念上说，merge函数通过应用on子句过滤，将源表行与目标表行进行联接，所有联接的行都在目标中进行更新或者删除。
He had hoped that the bulk of the money - once Udinese, Muntari's previous club, had received their payment due on a sell-on clause - would go to him for strengthening his squad.
他希望这笔钱能用来加强球队，不过蒙塔里的老东家乌迪内斯还能根据转卖条款拿走一笔钱。
They joined with the monarchists to insert a clause calling for a popular vote on the issue.
他们与君主制主义者一起添加了一个条款，要求对该问题进行全民投票表决。
If the project for some reason is unable to keep estimates current, then the estimation deliverables should include a clause indicating the conditions on which they remain valid.
如果由于一些原因，项目不能保持评估的更新，那么交付的评估就应该包括一些条款，以指示评估在什么条件下有效。
SQL embedded in programs on the application server might use the SQL system date clause.
在应用服务器上程序嵌入的SQL可能使用SQL系统日期子句。
It USES an additional source column on the SELECT clause in each UNION ALL view to indicate the source of the data.
它在每个NIONALL视图中的select子句上使用一个附加的源列表明数据的来源。
We express strong opposition to the unbridled interpretation on this clause by the Supreme Court of Japan regardless of China's repeated solemn representation.
我们对日本最高法院不顾中方多次严正交涉，对这一条款任意进行解释表示强烈反对。
If you need to create an index on an already existing (and populated) table, use the DEFER clause.
如果需要在一个已有的(并且被填充的)表上创建一个索引，那么可以使用defer子句。
The killer clause seized on by the Banks maintains that the fairness or otherwise of a contract cannot depend on the "adequacy of the price" but on whether its terms are stated clearly.
银行根据所执的关键性条款而坚持认为，合同的公平与否不能取决于“价格的适当”，而应取决于是否有明确的条款。
Listing 11's graph clause matches on each person node in the named FOAF graphs given to the query.
清单11的graph子句和提供给查询的命名图中的每个人员节点匹配。
The update clause will ensure that an update lock is held on the selected rows.
更新子句将确保更新锁定在被选择的行上。
On the basis of clause 15 of the contract, we place our claims before you as follows.
根据合同第15款，我方向贵方索赔如下。
Similar to DB2 UDB for Linux, UNIX, and Windows, in DB2 UDB for z/OS you can store and retrieve Unicode data if you have used the CCSID UNICODE clause on the object definitions, such as the following
与DB2UDBforLinux,UNIX,andWindows相似，在 DB2 UDBfor z/OS 中，如果您在对象定义上使用了CCSIDUNICODE子句，就可以存储并检索 Unicode数据，例如
Matched rows in the target table are updated or deleted based on update or delete clause specifications, as shown in Figure 2.
对于目标表中匹配的行，将依据更新或者删除子句规范来进行更新或者删除，如图2所示。
Mr Obama's people insist that it can-and that like a lot of other federal laws on taxation and the environment it is permitted by the commerce clause.
支持奥巴马的人民却坚信可以，就像大多数其他有关税收和环境的联邦法律一样，商业条款也允许该法案通过。
You can have distributed queries inside the using clause that access databases on more than one server instance.
可在访问处于多个服务器实例中的数据库的子句中包含分布式查询。
Include WHERE clause predicates for every column on the row to see if each column value is the same as its original value.
在行的每个列中包含where子句谓词，来确定每列的值是否与其初始值相同。
You can build a HQL WHERE clause using either binding parameters or simple string concatenation; the decision impacts on performance.
既可以使用绑定参数构造HQL的WHERE子句，也可以使用字符串拼接的方法，该决定对性能会有一定影响。
Usage: This parameter controls the decision on whether or not to apply a NON EMPTY clause on member requests when the number of tuples exceeds the set threshold.
用法：当元组数超过设定的阈值时，该参数控制是否对成员请求应用NONempty子句的决策。
DB2 automatically rewrites the queries with appropriate WHERE clause predicates depending on the data types used in the start and end columns of the temporal tables.
DB 2依据时态表的开始和结束列中使用的数据类型，使用合适的where子句谓词自动重写查询。
Ability to include a WHERE clause: the program allows you to restrict the rows based on conditions.
包含where子句的能力：程序允许您基于条件对行进行限制。
As my colleague Dan Primack reported on Friday, Bartz's Yahoo employment contract has a non-disparagement clause.
我的同事丹•普里·马克周五的一篇报道称，在巴茨与雅虎集团的雇佣合同里，包含非贬低条款。
As my colleague Dan Primack reported on Friday, Bartz's Yahoo employment contract has a non-disparagement clause.
我的同事丹•普里·马克周五的一篇报道称，在巴茨与雅虎集团的雇佣合同里，包含非贬低条款。
应用推荐