可以使用WHERE BETWEEN加入2个表吗？ [英] possible to join 2 tables using WHERE BETWEEN ?

问题描述

员工

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个表吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！