|< < 25 > >|

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?


project(
    select(
        join(Artist, Album),
        name == 'The Detroit Cobras')
    [title])

|< < 25 > >|