Resolved: Logically adjacent
I am not sure if I understood the concept of logically adjacent or not. How can I determine if two tables are logically adjacent or not? and why the two tables dept_manager and dept_emp are not logically adjacent but can be joined?
1 answers ( 1 marked as helpful)
Hi Fatma!
Thanks for reaching out.
Two tables are logically adjacent if they have some relationship - primary key from the first one and foreign key from the second one referencing this primary key. If two tables are not logically adjacent you can still join them.
Hope this helps.
Best,
Tsvetelin