In this chapter, you learn all about additional join types—what they are and how to use them. You also learn how to use table aliases and how to use aggregate functions with joined tables.
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 names. There are two primary reasons to do this:
• To shorten the SQL syntax
• To enable multiple uses of the same table within ...