select
emp.LAST_NAME,dept.DEPARTMENT_NAME,dept.LOCATION_ID
from
(employees emp NATURAL JOIN departments dept)
where emp.COMMISSION_PCT is not null;
select
emp.LAST_NAME,dept.DEPARTMENT_NAME,dept.LOCATION_ID
from employees emp,departments dept
where emp.DEPARTMENT_ID=dept.DEPARTMENT_ID
and emp.COMMISSION_PCT is not null;
老师,为什么这两种查询出来的结果会不一样呢?用NATURAL JOIN查询出来的数据要少很多。