1 Reply Latest reply on Mar 12, 2012 5:04 PM by Dimitri.B

    Database error 0x80004005: [Oracle][ODBC][Ora]ORA-00933: SQL command not properly ended

      Hi,

       

      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")

      LIMIT 1

       

      Please help. I'd be happy to provide more details if required.

       

      Thank you,

       

      Avanthi