Syntax errror in Join Operation

[coolscan3]

I have a Pass through query and am getting a syntax error in join operation.

sqlstr = "select fds.nonPMJobs.npmJobRef,fds.workorders.wodref " _
& " from fds.nonPMJobs " _
& " INNER JOIN fds.Workorders ON fds.NonPmJobs.npmJobRef = fds.Workorders.npmJobRef" _
& " where fds.NonPMJobs.loclevel3='WD23'"

Set qdf = db.CreateQueryDef("", sqlstr)

Help appreciated

 

[PHV]

A Pass through query should have a Connect property.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[coolscan3]

This is the Complete Code

constr = "ODBC;DSN=PlanetEnterprise;Description=PlanetEnterprise;DATABASE=PlanetEnterprise;Trusted_Connection=Yes"

sqlstr = "select fds.nonPMJobs.npmJobRef,fds.workorders.wodref " _
& " from nonPMJobs " _
& " INNER JOIN fds.Workorders ON fds.NonPmJobs.npmJobRef = fds.Workorders.npmJobRef" _
& " where (((fds.NonPMJobs.loclevel3)='WD23'))"


Set qdf = db.CreateQueryDef("", sqlstr)

qdf.Connect = constr

Set rst = qdf.OpenRecordset()


Set Me.Form.Recordset = rst

 

[PHV]

Have you tried to create the very same query manually ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886