一、示例数据
1.user表
2.departments表
二、查询SQL
1.内连接
select t1.*,t2.department_name
from user t1
join departments t2 on t1.department_id = t2.department_id;
2.(左)外连接
select t1.*,t2.department_name
from user t1
left join departments t2 on t1.department_id = t2.department_id;
三:结果分析
1.内连接查询结果:两表的交集
2.外连接查询结果:两表的交集+主表中不符合连接条件单符合查询条件的数据行
tips:注意连接条件和查询条件的区别!