提示:文章写完后,目录可以自动生成,如何生成可参考右边的帮助文档
一、实体对应关系
创建两张表:Student(学生表)和Title(荣誉头衔表),他们之间是一对多的对应关系
创建几条测试数据
二、试验
接下来,我们查询所有“优秀班干部”(即Type=2)的数据
1、left join
依次执行:
select * from Student AS S left join Title AS T on S.Id=T.SId
select * from Student AS S left join Title AS T on S.Id=T.SId and T.Type=2
select * from Student AS S left join Title AS T on S.Id=T.SId where T.Type=2
所得结果依次为:
结论:LEFT JOIN查询条件放到ON或WHERE后面是有很大区别的,在写复杂查询语句时,一定要注意这一点。
2、inner join
依次执行:
select * from Student AS S inner join Title AS T on S.Id=T.SId
select * from Student AS S inner join Title AS T on S.Id=T.SId and T.Type=2
select * from Student AS S inner join Title AS T on S.Id=T.SId where T.Type=2
结论:INNER JOIN查询条件放到ON或WHERE后面没有区别。