A similar technique is used when applying the unique filter to the outer query, with dot notation used to indicate the field by which results are to be filtered.
在对外部查询应用惟一筛选器时可使用类似的技术,点符号将用于说明筛选结果所依据的字段。
Outer joins may have a negative impact on query performance.
外部连接可能会对查询性能产生负面影响。
Since the OUTER of this NLJOIN, TBSCAN (2), is applying local predicates, you must also add the predicates to the count query.
因为该NLJOIN的outer即t BS CAN(2)应用于局部断言,必须将该断言增加到计数查询。
This query performs an outer join to compare the sales information for 10 particular stores for January and November.
这个查询会执行一个外连接操作,以便比较从 1 月份至 11 月份的10 个特殊商店的销售信息。
Also, we added the outer items element at the same time as we are generating the items XML in the query.
另外,在查询中生成商品xml的同时,我们添加了外层的Items元素。
Now, accumulate both the inner and outer to generate the query at MSJOIN (6), that is, FILTER (10) and TBSCAN (9) (same as TBSCAN (7)).
现在,把inner和outer累积起来生成MSJOIN(6)上的查询,即FILTER(10)和TBSCAN(9)(与TBSCAN(7)相同)。
In this regard, the query is similar to a left outer join in SQL.
从这种意义上说,查询与 SQL中的左外连接相似。
By using the for clause in the after-aggregation detail filter on a non-projected data item, the underlying query automatically projects and groups the item as the outer most column of the list.
通过在一个未投射的数据项上的after - aggregation细节过滤器中使用for子句,底层查询会自动将该项目投射并分组为列表的最外层列。
In the above query, you had to construct the outer Customer element and add the attributes from the CUSTXML column data.
在上面的查询中,必须构造外层的Customer元素并添加来自custxml列数据的属性。
Data, which specifies the fields to be imported from the outer SQL query.
指定从外部SQL查询导入的字段。
Lists topics on using joins to query multiple tables, such as how to create outer joins and how to join tables automatically.
列出关于使用联接查询多个表的主题,例如如何创建外部联接和如何自动联接表。
Lists topics on using joins to query multiple tables, such as how to create outer joins and how to join tables automatically.
列出关于使用联接查询多个表的主题,例如如何创建外部联接和如何自动联接表。
应用推荐