I haven’t used it myself, but I think join (and autojoin, which is an alias) are an INNER JOIN, joinFrom / joinTo are LEFT JOIN and RIGHT JOIN (not sure which way)