Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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."