No credit card required
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.
Back in Lesson 9, “Creating Calculated Fields,” you learned how to use aliases to refer to retrieved table columns. The syntax to alias a column looks like this:
In addition to using aliases for column names and calculated fields, SQL also enables you to alias table ...