MySQL Crash Course, 2nd Edition

16

Creating Advanced Joins

In this chapter, 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

In Chapter 10, “Creating Calculated Fields,” you learned how to use aliases to refer to retrieved table columns. The code to alias a column looks like this:

Input

Click here to view code image

SELECT Concat(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 ...