示例表
| |
查询结果
如下实现语句,查询结果都一致,但表位置有区别
表的位置决定 inner join / left join /right join 三种连接查询结果
1、inner join 表位置交换结果一致
2、leif join 与 right join 表位置决定目标表,左联以第一个表为目标表,右连以第二个表为目标表(目标表:即查询结果为 另外表以目标表数据为基础做匹配,显示匹配到的目标表数据,未匹配到则不显示)
select * from member.tr_login_name b;
select a.*,rowid from fund.fm_risk_assessment a;
select b.login_name,b.* from member.tr_login_name b
inner join fund.fm_risk_assessment a
on b.member_id = a.member_id
where b.login_name_type = 2
;
select b.login_name,b.* from fund.fm_risk_assessment a
inner join member.tr_login_name b
on b.member_id = a.member_id
--where b.login_name_type = 2
;
select b.login_name,b.* from fund.fm_risk_assessment a
left join member.tr_login_name b
on a.member_id = b.member_id
--where b.login_name_type = 2
;
select b.login_name,b.* from member.tr_login_name b
right join fund.fm_risk_assessment a
on a.member_id = b.member_id
--where b.login_name_type = 2
;
select b.login_name,b.* from member.tr_login_name b
right join fund.fm_risk_assessment a
on a.member_id = b.member_id
--where b.login_name_type = 2
;