Two relational tables are connected to SQ Trans,what are the possible errors it will

The only two possibilities as of I know is
Both the table should have primary key/foreign key relation ship
Both the table should be available in the same schema or same database