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

18.  Inner Join

Ben Brumm1 
(1)
Melbourne, VIC, Australia
 

Earlier in this book, we learned what a database was, and that it had several advantages over other ways of storing data. In this chapter, we’ll learn how to make the most of one of those advantages: the ability to view data from multiple tables at once.

Multiple Tables

In earlier chapters we created an employee table to store information about employees. We then created an office table and a sales_meeting table. The sales_meeting table was then renamed to customer_meeting. There were several reasons for creating these other two tables:
  • Ensure data is only stored in one place

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.