非等值连接

#2、非等值连接
#案例1:查询员工的工资和工资级别
SELECT * FROM `job_grades`;
SELECT `salary`,`employee_id` FROM `employees`;
SELECT `salary`,`grade_level`
FROM `employees` e,`job_grades` j
WHERE `salary`>=`lowest_sal`&&`salary`<=`highest_sal`
&&`grade_level`='A';