从另一个表中选择数据 SQL 选择查询

这是由 StaffID 连接的 2 个表

Job Table
=========
JobID AssignedTo(StaffID) Created By(StaffID)
1     2                   1
2     3                   2
Staff Table
============
StaffID Name
1       May
2       Bob
3       Mary

我需要 SQL 语句来获取具有相应员工名称的作业详细信息，但这样做时遇到问题，因为我无法区分列，因为它们使用相同的表。最终结果应如下所示

JobID Assigned To  Created By
1     Bob          May
2     Mary         Bob   

select J.JobId, S1.Name AS AssignedTo, S2.Name AS CreatedBy
from Job J
inner join Staff S1 on S1.StaffID = J.AssignedTo
inner join Staff S2 on S2.StaffID = J.CreatedBy