It is possible to join two tables without joining a foreign key column in one table with a primary key column in another table.

Question

Quizplus · Accepted Answer

It is possible to join two tables based on any common column, it does not necessarily have to be a foreign key-primary key relationship. However, it is recommended to maintain referential integrity by using appropriate foreign keys and primary keys.

It Is Possible to Join Two Tables Without Joining a Foreign