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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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."