Introduction to Joins

In this chapter, we’ll learn about the join clause and how we can combine information that exists in more than one table. We can attach labels to column headers to make those headers easier to read. We’ll select to display specific columns from a wide result set and count distinct values to get accurate count results. We’ll also learn about the left join and how we can ...