Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Partnerships Contact
Finderr

-317 The statement failed becuase you must have the same number of selected

columns in each UNION, INTERSECT, or MINUS query.

All rows that are produced in a union, intersect or minus must have the same format, so each SELECT statement in the union, intersect or minus must select the same number of columns. In this union, intersect or minus, one of the second or subsequent SELECT statements does not list the same number of columns as the preceding one. Review the entire union, intersect or minus, and check that all select lists are alike in number and data type. If no appropriate column exists for one of the statements, specify a literal value of the appropriate type at that position. For example, where you need to match a numeric column, specify a literal zero.