THe simple manual example
(SELECT a FROM tbl_name INNER JOIN xx WHERE conditons)
UNION
(SELECT a FROM tbl_name INNER JOIN xx WHERE conditions)
ORDER BY a
[Err] 1250 - Table ‘xxx‘ from one of the SELECTs cannot be used in field list
一、解决方案:在这里记录一下是如何解决的:THe simple manual example(SELECT a FROM tbl_name INNER JOIN xx WHERE conditons)UNION(SELECT a FROM tbl_name INNER JOIN xx WHERE conditions)ORDER BY a去掉你SQL中的order by,如上面的SQL语句一样二、参考文档:https://lists.mysql.com/mysql/167