Oracle - 关联查询

Oracle - 关联查询

1.非等值连接:没有外键关联,范围内的查询

select first_name||last_name,salary,j.* from employees,job_grades j 
where salary >= j.lowest_sal and salary <= j.highest_sal;

2.等值连接

• 连接n个表，至少需要n-1个连接条件

select e.*,d.* from employees e,departments d 
where e.department_id = d.department_id