Requirements to join two sources in source qualifier

Question

Elucidate what are the basic requirements to join two sources in the source qualifier?

Answer 1

i) Two sources must have primary and foreign key relationships.
ii) Two sources must have the matching data types.

Basic requirements to join two sources by source qualifier which is illustrated below:

i) Both sources must be in the same database
ii) The must have at least single column in the common with similar data types