Abstract
A join operation allows you to retrieve data from multiple tables in a single SELECT query. Two tables can be joined by a single join operator, but the result can be joined again with other tables. There must exist a same or similar column between the tables being joined.
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 Rahul Batra
About this chapter
Cite this chapter
Batra, R. (2018). Understanding Joins. In: SQL Primer. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-3576-8_11
Download citation
DOI: https://doi.org/10.1007/978-1-4842-3576-8_11
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-3575-1
Online ISBN: 978-1-4842-3576-8
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books