I will describe my problem in case someone has already solved or can help me to do it. I need to make an inner join between three non spatial tables through an OLE DB Connection, which are situated on a SQL Server. I found that the only way to perform an inner join in ARCGIS is through the "Make Query Table" tool. ¿Is this correct?
Specifically my problem is that when performing the join (even between two tables) I get An invalid SQL statement WAS Used error. I tried SQL syntax variants but always get the same error.
This is an example of a simple test I tried in the Query Builder of Make Query Table tool:
"dbo.TABLE1.SOC_NUMERO = dbo.TABLE2.SOC_NUMERO AND dbo.TABLE1.SUMI_NUMER = dbo.TABLE2.SUMI_NUMER"
When I verified the expression whithin the tool:
There was an error with the expression.
An invalid SQL statement was used. [dbo.TABLE2]"
Any idea what could be the problem?
Thank you in advance.