本文介绍了可以使用WHERE BETWEEN加入2个表吗?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
员工
employee
empID salary 1 1000 2 1500税
tax
ID minSalary maxSalary tax 1 900 1000 1.8 2 1001 2000 1.9预期结果
expected result
empID Salary tax 1 1000 1.8 2 1500 1.9如果工资介于minSalary和maxSalary
the value of tax is returned if salary is between the minSalary and maxSalary
推荐答案我假设您在Employee.EmpID和Tax.ID之间没有关系? 尝试: I assume you don't have a relationship between Employee.EmpID and Tax.ID? Try: SELECT e.empID, e.salary, t.Tax FROM Employee e, Tax t WHERE e.Salary BETWEEN t.minSalary AND t.maxSalary
更多推荐
可以使用WHERE BETWEEN加入2个表吗?
发布评论