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,

Hugo