Outer joins can be converted to inner joins by augmenting fact tables with default values for foreign keys.
可通过用针对外键的默认值来填充fact表,来将外部连接转换为内部连接。
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的更新。
应用推荐