Except if I wrote it by hand, it would be -

    SELECT *
    FROM employees
    LEFT JOIN positions ON employees.id = positions.employee_id

which isn't really that different.