select * from a,b代表什么?
1)单纯的select * from a,b是笛卡尔乘积
2)select * from a,b where a.id=b.id相当于inner join
具体测试,参考:https://www.cnblogs.com/zzliu/p/11370272.html
单独的join代表什么?
join 和 inner join区别
join等同于inner join
left join 和right join,会
LEFT JOIN 关键字会从左表 (table_name1) 那里返回所有的行,即使在右表 (table_name2) 中没有匹配的行。
比如:s.id on a.id s值为空,用的是左连接,那么右表没有匹配的行,会返回空值
left join 的条件用on 还是where?
on
例如:
select s.* ,d.dept_no from salaries s left join dept_manager d on s.emp_no = d.emp_no
非链表查询时的条件,可在on后面加and 或者使用where都行
select d.dept_no,s.emp_no,s.salary from dept_manager d join salaries s on d.emp_no = s.emp_no and d.to_date = s.to_date
where d.to_date = ‘9999-01-01’
SELECT d.dept_no, d.emp_no, s.salary
FROM dept_manager AS d INNER JOIN salaries as s
ON d.emp_no = s.emp_no
AND d.to_date = s.to_date
AND d.to_date = ‘9999-01-01’