比如有一张主表,一张子表,想以时间为单位,降序合并排列它们之间的信息,查询SQL如下:
SELECT * FROM (
SELECT m.`create_time`, m.`order_id` FROM order_main m
UNION SELECT s.`create_time`, s.`order_id` FROM order_sub s
) AS c
ORDER BY create_time DESC;
比如有一张主表,一张子表,想以时间为单位,降序合并排列它们之间的信息,查询SQL如下:
SELECT * FROM (
SELECT m.`create_time`, m.`order_id` FROM order_main m
UNION SELECT s.`create_time`, s.`order_id` FROM order_sub s
) AS c
ORDER BY create_time DESC;