Unexpected extra token: INNER

I'm runing into this error when trying to query the MAS200 4.3 PVX version via ODBC, any idea?



  • I am sorry, I am a MAS500 programmer and I was working in a project that involves MAS200SQL, I just realized that I have to read some documentation about PVX and ODBC Drivers in order to query MAS200PVX version.


    So the correct query is this:


    SELECT SO_SalesOrderHeader.SalesOrderNo, SO_SalesOrderDetail.SalesOrderNo
    FROM { OJ SO_SalesOrderHeader SO_SalesOrderHeader INNER JOIN SO_SalesOrderDetail SO_SalesOrderDetail ON SO_SalesOrderHeader.SalesOrderNo = SO_SalesOrderDetail.SalesOrderNo }


    Thanks anyway,