mysql两个具有相同结构的表 - 想要通过union获得一个公共字段

Question

I have two tables that have the same structure, I need a query to order by from both tables at the same time so that the array fetched with php grabs the order correctly out of the two tables selected with a single query at the same time.

avoiding selection of each table separately, storing on php arrays and then sorting.

Answer 1

According to the documentation, it should be just like you would think. Here is an example from the documentation:

(SELECT a FROM t1 WHERE a=10 AND B=1)
UNION
(SELECT a FROM t2 WHERE a=11 AND B=2)
ORDER BY a LIMIT 10;