等值连接:
select last_name,department_name form department d inner join employee e on e.department_id = d.depatment_id
非等值连接:
自连接:
外连接:
交叉连接: