课程: Practice It: SQL Joins

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Try it: Full outer join

Try it: Full outer join - SQL教程

课程: Practice It: SQL Joins

开始一个月试用 购买团队方案

Try it: Full outer join

“

- Let's practice some full outer joins in Adventure Works. The resulting data set will consist of all rows from both tables in the join with matched and unmatched rows. Like the left join, unmatched columns in a row will have no values. In some RDBMSs, you'll be able to use the full outer join between two tables with the syntax similar to this example. In SQLite we don't have a full outer join available for us to use. However, we can union two left joins together to create a similar result. It's also a great visual of how the full outer join works as well. And here's how that works, we take the left and right outer join and union those two statements together. The order of the columns in both statements in the union must match and be in the same order. Your challenge is to perform a full outer join on customers within the United States and the Internet Sales. You can use the customer address US view to help. So you'll…

内容