Abstract
We have looked at simple 1–Many relationships between tables (e.g., each member is associated with one member type), and we have also looked at self relationships (e.g., members may coach other members). Another situation that occurs frequently is where there is more than one relationship between the same two tables.
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
Notes
- 1.
Clare Churcher, Beginning Database Design: From Novice to Professional (New York: Apress, 2012).
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2016 Clare Churcher
About this chapter
Cite this chapter
Churcher, C. (2016). Multiple Relationships Between Tables. In: Beginning SQL Queries. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1955-3_6
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1955-3_6
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1954-6
Online ISBN: 978-1-4842-1955-3
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)