Outer joins can be converted to inner joins by augmenting fact tables with default values for foreign keys.
可通过用针对外键的默认值来填充fact表，来将外部连接转换为内部连接。
Note You should not optimize a cube's schema if you depend on inner joins between the fact table and dimension tables to exclude fact rows for the cube content.
如果依赖在事实表和维度表之间的内部连接来为多维数据集内容排除事实行，则不应该对该多维数据集执行进行优化。
Next time I'll continue with an article on the use of SQL queries to build complex queries such as joins, inner joins, master-detail relations, and updates on these joins.
下一次，我将继续用一篇文章说明如何使用SQL查询来构建复杂的查询，如joins、inner joins、master -detail关系，以及这些joins的更新。
The first part of this tutorial presents examples of inner and outer joins.
本教程的第一部分给出了关于内部连接和外部连接的例子。
MODIFIES SQL DATA in SQL table functions allows you to push even INSERT, UPDATE, DELETE and MERGE (data-change-operations) into the inner leg of correlated joins.
SQL表函数中的 MODIFIES SQLDATA使您甚至可以将INSERT、UPDATE、DELETE和MERGE （ 数据更改操作）放入到关联连接的内表中。
Table and use an AS clause to name these columns for the display with the ij tool. Because the query joins these two tables (by using an implicit inner join), you can select columns from both tables.
因为查询(通过使用隐式内连接)将两个表连接，您可以从两个表中选择列。
However, the benefit of the merge scan join is that the inner table does not have to be scanned repeatedly as it does for nested loop joins.
然而，合并扫描联接的好处是不必反复地扫描内部表因为其为嵌套循环联接工作。
BIRT also provides a special data set called a Joint data set that allows combining existing data sets using inner and outer joins.
BIRT还提供了一个叫做联合数据集(Joint Data Set)的特殊数据集以使用内外连接来整合现存的数据集。
BIRT also provides a special data set called a Joint data set that allows combining existing data sets using inner and outer joins.
BIRT还提供了一个叫做联合数据集(Joint Data Set)的特殊数据集以使用内外连接来整合现存的数据集。
应用推荐