Syntax error in JOIN operation, help!!

[gavray]

HI,

I get the following error when trying to query two tables from a strID, which is a unique job ID

Any ideas gratefully received, thanks

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in JOIN operation.

CODE-

sSQL="SELECT JobTable.Salary, JobTable.CompanyID, CompanyTable.ID, CompanyTable.Company"
sSQL=sSQL & " FROM JobTable AS Salary"
sSQL=sSQL & " INNER JOIN CompanyTable AS Company"
sSQL=sSQL & " ON CompanyTable.ID = JobTable.CompanyID"
sSQL=sSQL & " WHERE ID= " & strID & ""
sSQL=sSQL & " ORDER BY JobTable.Salary;"

cheers

Gav

 

[swilliams]

Your SQL statement should be:

sSQL="SELECT JobTable.Salary, JobTable.CompanyID, CompanyTable.ID, CompanyTable.Company"
sSQL=sSQL & " FROM JobTable"
sSQL=sSQL & " INNER JOIN CompanyTable"
sSQL=sSQL & " ON JobTable.CompanyID = CompanyTable.ID"
sSQL=sSQL & " WHERE JobTable.ID= " & strID
sSQL=sSQL & " ORDER BY JobTable.Salary;"

Simon