I want to join two tables. TableA to TableB.
TableA has a Primary Key but TableB has no foreign key.
They both have a column named Type1_ID. And Type1_ID is not a primary or foreign key in either table.
Is there a best practice approach in this type of situation?