select user1.id,user1.name from user1,user2
where trim(user1.name)=trim(user2.nickname)
and user1.status=1 and user2.status=0
-----------------------------------------
select user1.id,user1.name from user1 left join user2 on user1.name=useer2.nickname
where user1.status=1 and user2.status=0
where trim(user1.name)=trim(user2.nickname)
and user1.status=1 and user2.status=0
-----------------------------------------
select user1.id,user1.name from user1 left join user2 on user1.name=useer2.nickname
where user1.status=1 and user2.status=0
select user1.id,user1.name from user1 where exists(select 1 from user2 where user1.name=useer2.nickname and user2.status=0) and user1.status=1