Lesson 13. Creating Advanced Joins

In this lesson, you’ll learn all about additional join types—what they are and how to use them. You’ll also learn how to use table aliases and how to use aggregate functions with joined tables.

Using Table Aliases

Before we look at additional types of joins, we need to revisit aliases. Back in Lesson 7, “Creating Calculated Fields,” you learned how to use aliases to refer to retrieved table columns. The syntax to alias a column (in SQL Server) looks like this:

Input ▾

SELECT RTRIM(vend_name) + ' (' + RTRIM(vend_country) + ')'
        AS vend_title
FROM Vendors
ORDER BY vend_name;

In addition to using aliases for column names and calculated fields, SQL also enables you to alias table ...

Get Sams Teach Yourself SQL in 10 Minutes a Day, 5th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.