连接两个表的SQL [英] Joining two tables SQL

问题描述

我有一个问题.我有两个表employee和salary，我要显示所有级别的所有雇员的全名和薪级，这些员工的grade_ID为2或3，并按employee_ID排序.

I have a question. I have two tables employees and salary and I want to display the full name and salary grade of all employee who’s grade_ID is 2 or 3 sort by employee_ID.

以下是表格:

Salary_ID      LOW_SALARY       High Salary
1                1              250000
2                250001         500000
3                500001         750000
4                750001         999999

---

EMPLOYEE_ID     FIRST_NAME     Last_NAME   Salary
1               James          Smith       800000
22               Roy           Red         375000
2                Ron           Johnson     550000
5                Rob           Green       225000

我知道我必须加入表格，这是我到目前为止所拥有的:

I know I have to join the tables, this is what I have so far:

SELECT employees2.FIRST_NAME,
       employees2.last_name,
       salary_grades.SALARY_GRADE_ID,
       employees2.SALARY
FROM employees2,
     salary_grades
ORDER BY employees2.EMPLOYEE_ID;

下一步我要做什么?我被困住了.谁能帮我吗?谢谢你.

what do i do next? I am stuck. Can anyone help me out? Thank you.

推荐答案

可能是您要查询的查询:

It may be the query you're looking for:

SELECT E.EMPLOYEE_ID
    ,E.FIRST_NAME
    ,E.LAST_NAME
    ,E.SALARY
FROM employees E
INNER JOIN salary S ON S.LOW_SALARY <= E.SALARY
                      AND S.HIGH_SALARY >= E.SALARY
                      AND S.SALARY_ID IN (2,3)
ORDER BY E.EMPLOYEE_ID

希望这会对您有所帮助.

Hope this will help you.

这篇关于连接两个表的SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！