I am using Tableau 6.1 and am trying to establish an ODBC. I got this error while trying to connect to two tables in the Database, using an inner join clause. This is the query.
SELECT 1 AS "TEMP_oneA_"
FROM "ODSADMIN"."T_ORGSYNCORGANIZATION" "T_ORGSYNCORGANIZATION"
INNER JOIN "ODSADMIN"."T_ORGSYNCROSTER" "T_ORGSYNCROSTER" ON ("T_ORGSYNCORGANIZATION"."ORGANIZATION_ID" = "T_ORGSYNCROSTER"."ORGANIZATION_ID")
Please help. I'd be happy to provide more details if required.
As far as my ignorance of the subject allows me, Oracle doesn't support LIMIT clause in this context. Try removing it and see if the error goes away. If you need to limit the number of rows returned, use ROWNUM instead, as described, for example, here: http://www.club-oracle.com/forums/limit-clause-for-oracle-sql-t637/