一条记录中，多个字段来源于一个基础表，怎么进行关联

时　间:2019-06-13 12:01:17
作　者:易勋   ID：35404  城市：上海
摘　要:如果tblSalesOrder有一条记录，有创建者、修改者、审核人，这些字段都是来源于Sys_Users,在tblSalesOrder中保存的是Username，现在需要将创建者、修改者、审核人的Nickname在查询中显示出来，需要怎么处理？
正　文:

tblSalesOrder：

Sys_Users:

SQL语句如下：

Select tblSalesOrder.OrderNumber, tblSalesOrder.Creator, Sys_Users.Nickname AS CreateName, tblSalesOrder.Modifier, Sys_Users_1.Nickname AS MonifierName, tblSalesOrder.Auditor, Sys_Users_2.Nickname AS AuditorName
FROM Sys_Users AS Sys_Users_2 INNER JOIN (Sys_Users AS Sys_Users_1 INNER JOIN (Sys_Users INNER JOIN tblSalesOrder ON Sys_Users.Username = tblSalesOrder.Creator) ON Sys_Users_1.Username = tblSalesOrder.Modifier) ON Sys_Users_2.Username = tblSalesOrder.Auditor;

查询视图：