jeremysimmons
New Member
I certainly cannot do this:
select 1 UNION ALL
select 2 UNION ALL
select 3.
Syntax error at or about (statement excerpt). (10713)
SQL-92 found a sql syntax error in the sql statement sent to it by the client. "statement excerpt" is the portion of the statement where the syntax error was found. The beginning of the excerpt is where SQL-92 detected the syntax error.
I also cannot do this
select 1 FROM table_with_no_rows UNION ALL
select 2 FROM table_with_no_rows
because I get back 1 row.
What's the solution for this?
select 1 UNION ALL
select 2 UNION ALL
select 3.
Syntax error at or about (statement excerpt). (10713)
SQL-92 found a sql syntax error in the sql statement sent to it by the client. "statement excerpt" is the portion of the statement where the syntax error was found. The beginning of the excerpt is where SQL-92 detected the syntax error.
I also cannot do this
select 1 FROM table_with_no_rows UNION ALL
select 2 FROM table_with_no_rows
because I get back 1 row.
What's the solution for this?