presto join type

presto join type

JOIN だけだと INNER JOIN として扱われる。そうですね。

[ INNER ] JOIN
LEFT [ OUTER ] JOIN
RIGHT [ OUTER ] JOIN
FULL [ OUTER ] JOIN
CROSS JOIN

https://prestodb.io/docs/current/sql/select.html