|< < 21 > >|

Natural Join

Compare these queries


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])

Schema

  • Same join.
  • Same structure (join, then select, then project).
  • Columns involved in select and project have "swapped" positions.
  • Would these be symmetrical in a hierarchical database?

|< < 21 > >|