IP Execute function returned Error on running a UNION to join Department Name with a string, such as:
SELECT FULL_NAMEFROM DEPARTMENTSUNIONSELECT '- Unclassified -'
Query failed: DBSQLSelect() SQLExecuteDirect - Error 10263 HY000 [DataDirect][ODBC OpenAccess SDK SQL Engine]IP Execute function returned error.
Standard SQL requires the From clause and Table Name when using UNION for both Selects in the query.
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