[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/167276