Chapter 17
Retrieving Data from More Than One Table
Abstract
This chapter presents SQL syntax for retrieving data from more than one table in a single query. Techniques include basic joins (original and modern syntax), outer joins, joining a table to itself, table constructors, and uncorrelated subqueries.
Keywords
SQL
SQL SELECT
SQL joins
SQL retrieval
outer join
subqueries
SQL IN operator
SQL ANY operator
multi-table queries
As you learned in the first part of this book, logical relationships between entities in a relational database are represented by matching primary and foreign key values. Given that there are no permanent connections between tables stored in the database, a DBMS must provide some way for users to match primary and foreign ...
Get Relational Database Design and Implementation, 4th Edition 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.
