AWS Athena (Presto) - inner join syntax-CodePudding

Home > other > AWS Athena (Presto) - inner join syntax

AWS Athena (Presto) - inner join syntax

Time：01-16

What is wrong with this statement?

select e.*
FROM 
    edgar_revenue as e,
    INNER JOIN xbrl as x
    ON x."cik" = e."cik"

line 4:5: mismatched input 'INNER'. Expecting: '(', 'LATERAL', 'UNNEST',

CodePudding user response：

I suspect it is the comma(,) after e

SELECT e.*
FROM 
edgar_revenue AS e
INNER JOIN xbrl AS x
ON x."cik" = e."cik"