Beginning SQL Queries: From Novice to Professional, Second Edition

© Clare Churcher 2016

Clare Churcher, Beginning SQL Queries, 10.1007/978-1-4842-1955-3_6

6. Multiple Relationships Between Tables

Clare Churcher¹ 

(1)Studio B Productions, Great Neck, New York, USA

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.

Two Relationships Between the Same Tables

Let’s consider how we might introduce the idea of teams into the golf club database. We can start off by thinking about what basic information we need to keep about a team. Figure 6-1 shows a class representing ...