qq_43281464的博客

记录日常 比如 这个才能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 AL