2 Replies Latest reply on Apr 25, 2012 9:47 AM by gizagui

    Make Query Table and Inner Joins

      Hi everybody,

      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:


      When I verified the expression whithin the tool:

      "Verifying expression...
      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.