RE: INSERT INTO tbl (SELECT) UNION (SELECT) ORDER BY field-does not work. Why?

George Georgeus wrote: Hi! I do not know how to use INSERT and UNION together. For example: INSERT INTO tmp_table_name (a) (SELECT a FROM table_name WHERE a=10 AND B=1 ORDER BY a LIMIT 10) UNION (SELECT a FROM table_name WHERE a=11 AND B=2 ORDER BY a LIMIT 10) ORDER BY a; It does not work.

Re: INSERT INTO tbl (SELECT) UNION (SELECT) ORDER BY field-does not work. Why?

Hi! On Dec 02, George Georgeus wrote: Hi! I do not know how to use INSERT and UNION together. For example: INSERT INTO tmp_table_name (a) (SELECT a FROM table_name WHERE a=10 AND B=1 ORDER BY a LIMIT 10) UNION (SELECT a FROM table_name WHERE a=11 AND B=2 ORDER BY a LIMIT 10) ORDER BY a;