select
a.'user_name',
a.'over',
b.'over'
from
user1 a
inner join
user2 b
on
a.'user_name'=b.'user_name'
;
2、Left Outer join 链接
select
a.'user_name',
a.'over',
b.'over'
from
user1 a
left join
user2 b
on
a.'user_name'=b.'user_name'
where
b.user_name is null
;
3、Right Outer Join 链接查询
select
b.'user_name',
b.'over',
a.'over'
from
user1 a
Right join
user2 b
on
a.'user_name'=b.'user_name'
where
a.user_name is null
;
4、Full join 链接查询(MySQL不支持此操作,可通过 union all 替代)
select
a.'user_name',
a.'over',
b.'over'
from
user1 a
left join
user2 b
on
a.'user_name'=b.'user_name'
where
b.user_name is null;
union all
select
b.'user_name',
b.'over',
a.'over'
from
user1 a
Right join
user2 b
on
a.'user_name'=b.'user_name'
where
a.user_name is null
;