SQL中left join和 right join的区别

SQL join

数据库中两张表：student和 score

1、LEFT JOIN

SELECT * FROM student  st LEFT JOIN score sc ON st.student_id = sc.student_id ORDER BY st.student_id

2、INNER JOIN

SELECT * FROM student st  INNER JOIN score sc ON st.student_id = sc.student_id ORDER BY sc.student_id
-- inner 可以省略

3、RIGHT JOIN

SELECT * FROM student st  RIGHT JOIN score sc ON st.student_id = sc.student_id ORDER BY st.student_id

4、RIGHT JOIN 转成 LEFT JOIN

select * from t1 right join t2 on t1.id = t2.id;
-- 能转化为
select * from t2 left join t1 on t1.id = t2.id;