I am studying table design in SQL, and I am wondering how to create a mapping table to establish a many-to-many relationship between two other tables?
I think the mapping table needs two primary keys, but I cannot figure out how to create it, since it can only contain 1 column of the primary key?
I use the "Database Charts" function to create my tables and relationships.
source
share