Can I join these two tables?
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?
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?
STHOMP02169
Joining on a primary or foreign key isn't required. You do want to make your join unique though. Can you provide a little more infromation on the nature of the two tables? Do both contain attributes of a specific fact? or does TableB define Type1_ID?
ASKER
Yes on the attributes.
Type1_ID column in TableA & TableB are define the same.
Type1_ID column in TableA & TableB are define the same.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.