Outer joins can be converted to inner joins by augmenting fact tables with default values for foreign keys.

可通过用针对外键的默认值来填充fact表，来将外部连接转换为内部连接。

youdao

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.

如果依赖在事实表和维度表之间的内部连接来为多维数据集内容排除事实行，则不应该对该多维数据集执行进行优化。

youdao

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的更新。

youdao