In this chapter, you'll learn all about additional join typeswhat 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.