Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Incorrect syntax near keyword 'INNER'

I have been trying to join two tables, an incident table and and a company table

Incident:

SQL SELECT 

    Company_Id,

    Last_Updated

    Company.Country,

    Company.Company_Name

FROM

      Incidents

WHERE

      Create_Date >= '2012-01-01'

ORDER BY

      Last_Updated

INNER JOIN

    Company ON Incidents.Company_Id=Company.Company_Id;

Any ideas why I get the syntax error?

10 Replies
swuehl
MVP
MVP

The Help also states:

"However, the extent to which the SELECT statements are accepted depends largely on the ODBC driver or OLE DB provider used."