我有两张桌子.
我这样查询:
SELECT * FROM (
Select requester_name,receiver_name from poem_authors_follow_requests as one
UNION
Select requester_name,receiver_name from poem_authors_friend_requests as two
) as u
where (LOWER(requester_name)=LOWER('user1') or LOWER(receiver_name)=LOWER('user1'))
我正在使用UNION,因为如果第一个表和第二个表中存在用户,我想为每个用户获取不同的值.
例如:
table1
nameofuser
peter
table2
nameofuser
peter
如果peter在任一个表上,我应该得到一次名称,因为它存在于两个表中.
我仍然从第一张桌子获得一排,从第二张桌子获得第二排.怎么了?
任何帮助赞赏.