java UNION ALL 使用

记录日常
比如 这个才能sql，我是用联表查询，然后需要从两个字段中，颠倒查一下获得结果。
SELECT f.ID,
f.APPLY_ID,
f.ADD_TIME,
f.APPLY_TIME,
u.username,
u.phone
FROM friend f
INNER JOIN USER u ON f.APPLY_ID = u.uid
WHERE f.FRIEND_STATUS is null
AND f.STATUS is null
AND f.BYAPPLY_ID = #{uid}
UNION ALL
SELECT f.ID,
f.BYAPPLY_ID AS APPLY_ID,
f.ADD_TIME,
f.APPLY_TIME,
u.username,
u.phone
FROM friend f
INNER JOIN USER u ON f.BYAPPLY_ID = u.uid
WHERE f.STATUS is null
AND f.APPLY_ID = #{uid}

然后你获取到结果有重复的可以选择在代码中去重。