A Join clause works just like joins for relational databases. It finds rows in each dataset that match a specified condition and create result rows that join the columns from each dataset.

RAQL supports inner joins, natural joins and cross joins, but does not support outer joins. Inner joins are most common and thus are the default.

The Select clause identifies columns to include in the result from both datasets. Column names are prefixed by the dataset they belong to. The From clause identifies one dataset, followed by the Join clause that identifies the second dataset.

This example uses the on condition syntax to determine which rows to join, but RAQL also supports the using column-list syntax. Since the column name for the condition is identical in both dataset, you could also use: