Table Joins
In this assignment, you will investigate the methods of combining data tables in order to extract data from a database. Specifically, you will learn about two types of joins to combine tables-inner and outer joins. Once you c o m p l e t e this assignment, you would have gained an understanding of when to use each type of join.
What are the differences between an inner join and an outer join? Describe in your own words.
When would you use one type of join versus the other? Provide at least two examples of each type of join.