显示内连接:
select
emp.id,
emp.ename,
emp.salary,
job.jname,
job.description
dept.dname,
dept.loc
from
emp
inner join job on emp.job_id = job.id;
inner join dept on dept.id = emp.dept_id ;
select emp.ename,emp.salary,t2.* from emp,salarygrade t2 where emp.salary >= t2.losalary and emp.salary <= t2.hisalary