SELECT 订单表.订单id, 员工表.姓名 AS 业务员, 员工表_1.姓名 AS 审核, 员工表_2.姓名 AS 批准, 订单表.金额 FROM 订单表 INNER JOIN 员工表 ON 订单表.业务员 = 员工表.id INNER JOIN 员工表 AS 员工表_1 ON 订单表.审核 = 员工表_1.id INNER JOIN 员工表 AS 员工表_2 ON 订单表.批准 = 员工表_2.id
----------------------------------------------
武汉天气不好
SELECT 订单表.订单id , ( SELECT 姓名 FROM 员工表 WHERE 员工表.id = 订单表.订单id ) AS 业务员 , ( SELECT 姓名 FROM 员工表 WHERE 员工表.id = 订单表.订单id ) AS 审核 , ( SELECT 姓名 FROM 员工表 WHERE 员工表.id = 订单表.订单id ) AS 批准 , 订单表.金额 FROM 订单表;
----------------------------------------------
-
上面没住意写错了,修改了下 SELECT 订单表.订单id , ( SELECT 姓名 FROM 员工表 WHERE 员工表.id = 订单表.业务员 ) AS 业务员 , ( SELECT 姓名 FROM 员工表 WHERE 员工表.id = 订单表.审核 ) AS 审核 , ( SELECT 姓名 FROM 员工表 WHERE 员工表.id = 订单表.批准 ) AS 批准 , 订单表.金额 FROM 订单表;
----------------------------------------------
-