I want to understand the differences in Presto SQL (result-wise and performance-wise) between the following 2 queries:
SELECT
table1.field1, table1.field2, table2. field3
FROM
table1
JOIN (or INNER JOIN)
table2
ON
table1.key1 = table2.key2
SELECT
table1.field1, table1.field2, table2. field3
FROM
table1, table2
WHERE
table1.key1 = table2.key2
Want to understand the differences. I tried to run the 2 queries on some SQL engine, and it seems that at least these 2 queries are the same result-wise, but I still want to confirm it here.
New contributor
Zijiang Hao is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.