关于SQL语句中UNION使用ORDER BY排序失效的解决方法

写在前面:把两个分别有order by的查询语句用 union 连接起来，不分别加limit的话，各自的排序功能会失效。
今天开发中遇到一个业务功能，需要把有面试邀请的 和 没有面试邀请的投递记录 分别按时间从新到旧排序
在网上找了方法 大多千篇一律(不生效)···>如下:

select * from (SELECT t3.id,t2.COMPANY_NAME AS companyName,t1.ADD_TIME as time ,sd1.DICT_NAME as SALARY,t2.CONTACT_PERSON as person,t2.PHONE phone,t.PLACE,t.`NAME`,
t3.INTERVIEW_TIME as ADD_TIME, t3.TYPE ,
case when now()>=t3.INTERVIEW_TIME then '开始面试' else '未开始' end as interviewName,
t.AGE, t3.INTERVIEW_STATUS interviewResult,t1.`STATUS` as deliverStatus
FROM t_pub_position  t JOIN t_pub_deliver  t1 on t1.POST_ID=t.ID
JOIN t_pub_company t2 on t2.ID=t.COMPANY_ID
LEFT JOIN t_pub_interview t3 on t3.POST_ID=t.ID AND t1.USER_ID=t3.USER_ID JOIN smdb_dict sd1 ON sd1.DICT_ID=t.SALARY
WHERE (t3.INTERVIEW_STATUS = 0 or t3.INTERVIEW_RESULT =2) AND t1.USER_ID = 'wxl' order by ADD_TIME desc) tt
UNION
select * from (SELECT t.id,t2.COMPANY_NAME AS companyName,t1.ADD_TIME as time ,sd1.DICT_NAME as SALARY,t2.CONTACT_PERSON as person,t2.PHONE phone,t.PLACE,t.`NAME`,
'' AS ADD_TIME,'' as TYPE,
'' AS interviewName,
t.AGE, '' AS interviewResult,t1.STATUS as deliverStatus
FROM t_pub_position  t
JOIN t_pub_deliver  t1 on t1.POST_ID=t.ID
JOIN t_pub_company t2 on t2.ID=t.COMPANY_ID JOIN smdb_dict sd1 ON sd1.DICT_ID=t.SALARY
WHERE t1.USER_ID = 'wxl'  AND t1.STATUS <> '3' order by time desc) ttt

时间排序不生效 默认asc！
把两个分别有order by的查询语句用 union 连接起来，不分别加limit的话，各自的排序功能会失效

select * from (SELECT t3.id,t2.COMPANY_NAME AS companyName,t1.ADD_TIME as time ,sd1.DICT_NAME as SALARY,t2.CONTACT_PERSON as person,t2.PHONE phone,t.PLACE,t.`NAME`,
t3.INTERVIEW_TIME as ADD_TIME, t3.TYPE ,
case when now()>=t3.INTERVIEW_TIME then '开始面试' else '未开始' end as interviewName,
t.AGE, t3.INTERVIEW_STATUS interviewResult,t1.`STATUS` as deliverStatus
FROM t_pub_position  t JOIN t_pub_deliver  t1 on t1.POST_ID=t.ID
JOIN t_pub_company t2 on t2.ID=t.COMPANY_ID
LEFT JOIN t_pub_interview t3 on t3.POST_ID=t.ID AND t1.USER_ID=t3.USER_ID JOIN smdb_dict sd1 ON sd1.DICT_ID=t.SALARY
WHERE (t3.INTERVIEW_STATUS = 0 or t3.INTERVIEW_RESULT =2) AND t1.USER_ID = 'wxl_7910781722108243' order by ADD_TIME desc  limit 999) tt
UNION
select * from (SELECT t.id,t2.COMPANY_NAME AS companyName,t1.ADD_TIME as time ,sd1.DICT_NAME as SALARY,t2.CONTACT_PERSON as person,t2.PHONE phone,t.PLACE,t.`NAME`,
'' AS ADD_TIME,'' as TYPE,
'' AS interviewName,
t.AGE, '' AS interviewResult,t1.STATUS as deliverStatus
FROM t_pub_position  t
JOIN t_pub_deliver  t1 on t1.POST_ID=t.ID
JOIN t_pub_company t2 on t2.ID=t.COMPANY_ID JOIN smdb_dict sd1 ON sd1.DICT_ID=t.SALARY
WHERE t1.USER_ID = 'wxl_7910781722108243'  AND t1.STATUS <> '3' order by time desc limit 999) ttt

生效了！！！