Join右外连接(Right Outer)概述:
右表与左表结合,取右表全部属性,左表若无则写null;
1、首先,你还是要有两个表:
表1:people
表2:students
2、然后,进行SQL语句操作
SELECT students.s_name,students.s_age,people.p_sex
FROM students
RIGHT JOIN people
ON students.s_name=people.p_name
ORDER BY students.s_name;
3、结果如下:
Idea连接数据库(MySql Workbench)
Idea数据库操作(Inner Join)
Idea数据库操作(Left Join)