Python for Everybody (py4e.com)
These are the lectures to supplement the textbook 'Python for Everybody: Exploring Information' and its associated web site py4e.com
Python for Everybody (py4e.com)
15.6 Multi-Table Retrieval using JOIN
•
Dr. Charles Russell Severance
Use Left/Right to seek, Home/End to jump to start or end. Hold shift to jump forward or backward.
We look at how to reconstruct complete views of the data when data is properly distributed across multiple tables and connected via foreign keys. We learn the JOIN operation and ON clause in SQL.