|< < 23 > >|

Foreign keys have a "direction", joins do not

Foreign key direction

  • A foreign key has a direction. One table references the other.
  • The referenced table has no declaration to indicate that the FK exists.

Joins have no direction

  • The join is the same, regardless of which way the query "navigates".

What are the titles of albums by The Detroit Cobras? Who created My Aim is True?
project( select( join(Artist, Album), name == 'The Detroit Cobras') [title]) project( select( join(Artist, Album), title == My Aim is True') [name])

|< < 23 > >|