Abstract
Most real-life queries combine data from multiple tables instead of querying a single table. Logic may be encapsulated in a view to hide complexity from the end user, but the database accesses multiple tables anyway to get the result set. It’s not necessary that data from all tables in a query appear in the result; some tables may be used to filter out data from other tables, for example.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2018 Alex Reprintsev
About this chapter
Cite this chapter
Reprintsev, A. (2018). Joins. In: Oracle SQL Revealed. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-3372-6_1
Download citation
DOI: https://doi.org/10.1007/978-1-4842-3372-6_1
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-3371-9
Online ISBN: 978-1-4842-3372-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books