多表连接之—非等值连接
#2.非等值连接
#案例1:查询员工的工资以及对应的工资级别
SELECT salary,grade_level
FROM employees e,job_grades g
WHERE e.`salary` BETWEEN g.`lowest_sal` AND
g.`highest_sal`;
#2.非等值连接
#案例1:查询员工的工资以及对应的工资级别
SELECT salary,grade_level
FROM employees e,job_grades g
WHERE e.`salary` BETWEEN g.`lowest_sal` AND
g.`highest_sal`;