摘要: 数据库多表笔记 SELECT t1.ename , t1.`salary`, t2.* FROM emp t1, salarygrade t2 WHERE t1.`salary` BETWEEN t2.`losalary` AND t2.`hisalary`; -- 4.查询员工姓名,工资,职务名称 阅读全文
posted @ 2020-11-13 21:18 大风吹爱护 阅读(55) 评论(0) 推荐(0) 编辑