Do to tables have to have a primary and foreign key to be able to perform a join query?
Do to tables have to have a primary and foreign key to be able to perform a join query?
You can join by any common column name. It doesn't have to be a key.
https://www.w3schools.com/sql/sql_join.asp