Joinable implementation of SQL one-to-one relation
Equivalent to SQL FROM
FROM
Equivalent to SQL INNER JOIN
INNER JOIN
Equivalent to SQL LEFT OUTER JOIN
LEFT OUTER JOIN
Used for clarity only and match SQL queries
Equivalent to SQL
FROM