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