#案例：查询员工的工资和工资级别

SELECT salary,grade_levelFROM employees AS e,job_grades AS jWHERE salary BETWEEN j.`lowest_sal` AND j.`highest_sal` #e表的salary字段会和j表的每行字段挨个比较