5 ms·
>By far the most common case for joins is following foreign keys. SQL has no special syntax for this That's because there can be more than one FK relationship
by ComodoHacker 5y ago
>By far the most common case for joins is following foreign keys. SQL has no special syntax for this
That's because there can be more than one FK relationship between the same two tables. For example, if we model a binary tree, there could be references to left, right and parent nodes.