需要帮助MySQL查询。 需要来自两个表的数据

I am a beginner in MySQL.

Table 1: Users

ID   NAME
----------
1    XYZ
2    ABC

Table 2: Task

ID   TASK_NAME   ASSIGNED_BY    ASSIGNED_TO
--------------------------------------------
1    task 1         1               2 
2    task 2         2               1 

I want this result.

ID   TASK_NAME   ASSIGNED_BY    ASSIGNED_TO
--------------------------------------------
1    task 1         XYZ             ABC 
2    task 2         ABC             XYZ 

Its a simple JOIN task:

SELECT t.ID, t.TASK_NAME, 
       u1.NAME AS ASSIGNED_BY,
       u2.NAME AS ASSIGNED_TO
FROM Task AS t
JOIN Users AS u1 ON t.ASSIGNED_BY = u1.ID
JOIN Users AS u2 ON t.ASSIGNED_TO = u2.ID

You need to use JOIN to do it. I use INNER JOIN please try the following query.

SELECT t.ID, t.TASK_NAME, 
       u1.NAME AS ASSIGNED_BY,
       u2.NAME AS ASSIGNED_TO
FROM Task AS t
INNER JOIN Users AS u1 ON t.ASSIGNED_BY = u1.ID
INNER JOIN Users AS u2 ON t.ASSIGNED_TO = u2.ID