Join

    • decides which rows to include, defaulting to inner.
    • Table reference
    • List of conditions
      • The result of join operation is a cartesian (cross) product of rows from both tables, which is then filtered to match all of these conditions.

    PRQL

    2. join side:left positions [employees.id==positions.employee_id]

    SQL

    PRQL

    1. from employees

    SQL

    If the join conditions are of form left.x == right.x, we can use “self equality operator”:

    1. from employees