数据库——连接（自然连接、外连接、内连接）

1、自然连接：只考虑那些在两个关系模式中都出现的属性上取值相同的元组对 natural join、join...using

select A1,A2,...,An
from r1 natural join r2 natural join ... natural join rn
where P;

select name1, course_id
from instructor, teaches
where instructor.ID = teaches.ID;

等价于

select name1, course_id
from instructor natural join teaches；