views:

16

answers:

1

Title pretty much sums it up.

Is there a technical name given to a table that stores primary key from two separate tables to create a linkage.

i.e.
car ( id, manufacturer, model, year, vin),
passenger ( id, name ),
linkage_table ( car, passenger )

Where car stores value of the id column from the car table and passenger stores the value of id column from the passenger table.

SELECT c.*, p.*
FROM car c, passenger p, linkage_table l
WHERE c.id = 15
AND c.id = l.car
AND p.id = l.passenger

+1  A: 

It's called a junction table, and is used in a Many-to-Many relationship.

Mike DeSimone