© Ben Brumm 2019
Ben BrummBeginning Oracle SQL for Oracle Database 18chttps://doi.org/10.1007/978-1-4842-4430-2_21

21. Joining Many Tables

Ben Brumm1 
(1)
Melbourne, VIC, Australia
 
In this chapter, we’ll learn how to use SQL to join many tables together in our query. So far, we’ve learned quite a bit about joins:
  • What a join is (a way of relating two tables together in a query)

  • What an inner and outer join is

  • The different types of outer joins (left, right, full)

  • Some other join types that are available if needed (cross join) or that are not recommended (natural join)

  • The alternative join syntax (the WHERE clause)

All of the topics so far have only worked with two tables at a time: either the employee and office table, or the employee and sales_meeting ...

Get Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.