Relationships/Joining Tables

When tables are related together or ‘joined’ a column of one

contains the “primary key” of another (called a foreign key)

23

Primary Key

23

x

y

record with primary key 23

Foreign Key

Previous slide

Next slide

Back to first slide

View graphic version