The original issue is no records are showing when I link 2 tables together on a field. I know that the field in both are the same and the join should bring back a result, but it does not bring anything back.

I am connecting to the database via the application using ODBC.

When I use the command option to create my own select statement I get a connection error:-.

“failed to open rowset details: 3700 :[AR System ODBC Driver] unexpected extra token inner join”

The select statement I created included a trim as this made the connect work when I tested it in MS access. The join field is on the instanceID, which is the primary key in one table and foreign key in the other

SELECT "BMC_CORE_BMC_ApplicationSystem"."Name",
 FROM   "BMC_CORE_BMC_ApplicationSystem" "INNER JOIN "BMC_CORE_BMC_Application"  ON trim("BMC_CORE_BMC_ApplicationSystem"."InstanceId")=trim("BMC_CORE_BMC_ApplicationSystem_1"."InstanceId")

The application I am trying to connect to is BMC Remedy

Can anyone suggest how I can change the syntax of the statement I created so that the statement will be accepted?

Can anyone suggest what could be the original issue with the connectivity?

Thanks