AnsweredAssumed Answered

com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC] FQL0001/(1:79)

Question asked by narasimhakamasani on Jul 8, 2015
Latest reply on Jul 9, 2015 by narasimhakamasani

Title

com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC] FQL0001/(1:79)

Post

Hi

SELECT * FROM VL_Contact_Type INNER JOIN Contractor ON VL_Contact_Type.__ContactType_ID_fk = Contractor.___ContactType_ID_pk

when i write the above joing query  i am getting following exception

When ever i am using Joins i am facing this Issue.

com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC] FQL0001/(1:79): There is an error in the syntax of the query.

 

Can u please guide me how to resolve it.

 

Outcomes