ODBC > IP Execute function Error when Running a UNION

IP Execute function returned Error on running a UNION to join Department Name with a string, such as:

SELECT FULL_NAMEFROM DEPARTMENTSUNIONSELECT '- Unclassified -'

Result:
Query failed: DBSQLSelect() SQLExecuteDirect - Error 10263 HY000 [DataDirect][ODBC OpenAccess SDK SQL Engine]IP Execute function returned error.

Reason:
Standard SQL requires the From clause and Table Name when using UNION for both Selects in the query.

Solution:
Enter From clause and a Table Name for the second select in the Union. Correct format would be:

SELECT FULL_NAMEFROM DEPARTMENTSUNIONSELECT '- Unclassified -'FROM DEPARTMENTS