记录日常
java伪表的使用。
比如现在你用了两个联表查询后,需要在两个的结果中获取你指定的结果,
就可以这样写
select * from{
这里写联表查询片段
UNION ALL
另一个联表查询
} A
写你的条件上代码,可以看的跟详细点,
SELECT A.ID, A.APPLY_ID, A.ADD_TIME,A.APPLY_TIME, A.username, A.phone FROM ( 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.BYAPPLY_ID = u.uid WHERE f.BYAPPLY_ID = #{uid} AND f.FRIEND_STATUS = 10 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.APPLY_ID = #{uid} AND f.FRIEND_STATUS = 10 ) A AND A.phone LIKE CONCAT('%',#{phone},'%') AND A.username LIKE CONCAT('%',#{username},'%') LIMIT #{page},#{size}