Microsoft Access - missing operator in Inner Join query

Asked By rahat baloch on 14-Feb-10 03:55 AM
I am trying to run this query but getting "MISSING (operator) in query or experssion.

Could you please help

strSQL = "SELECT txtLicenseType,dtIssueDate, dtExpiryDate,txtLicenseNo INNER JOIN tblPropertyLicense ON " & _
        "tblLicense.IntLicenseID = tblPropertyLicense.IntLicenseID   WHERE tblPropertyLicense.IntFileID  = " & intId


thanks
Venkat K replied to rahat baloch on 14-Feb-10 05:50 AM
Syntax Error:

You are missing the first table name FROM tblName1

strSQL = "SELECT txtLicenseType,dtIssueDate, dtExpiryDate,txtLicenseNo FROM tblName 1 INNER JOIN tblPropertyLicense ON " & _
        "tblLicense.IntLicenseID = tblPropertyLicense.IntLicenseID   WHERE tblPropertyLicense.IntFileID  = " & intId

Thanks,
Venkat K replied to rahat baloch on 14-Feb-10 05:51 AM
Syntax Error:

You are missing the first table name FROM tblName1

strSQL = "SELECT txtLicenseType,dtIssueDate, dtExpiryDate,txtLicenseNo FROM tblLicense INNER JOIN tblPropertyLicense ON " & _
        "tblLicense.IntLicenseID = tblPropertyLicense.IntLicenseID   WHERE tblPropertyLicense.IntFileID  = " & intId

Thanks,