Return
-
Title
Error joining two tables in Query Builder: "ORA-00933: SQL command not properly ended". -
Description
When joining 2 or more tables in Toad for Data Analysis connected to an Oracle 8i database, the following error occurs when the generated script is executed.
"ORA-00933: SQL command not properly ended" -
Cause
The generated Structured Query Language (SQL) script uses American National Standards Institute (ANSI) SQL joins which is not compatible with Oracle 8i.
-
Resolution
Select "ANSI Joins" menu option from the "Query Builder" menu or click the "Use ANSI joins in query" button on the Query Builder's Toolbar to disable ANSI joins, in order to use simple joins instead.