mysql - 拉入另一列进行查询

Question

我有一个查询，需要在其中添加一个附加列。我的灰质暂时死亡，需要帮助。

按原样查询

SELECT g.groupId,g.name AS groupName,l.logId,l.name AS logName, i.itemID,
i.name AS itemName, le.userName,completed, i.optimalMin,i.optimalMax ,le.value,
u.name AS unitDescription,g.parentId
FROM logExceptions le
INNER JOIN logs l ON l.logID = le.logID
INNER JOIN groups g ON g.groupId = l.groupId
INNER JOIN items i ON le.itemId = i.itemId
INNER JOIN units u ON i.unitId = u.unitId

列名实际上是 l.name，但针对的是parentId。所附图片将显示我的意思。

Answer 1

解决方案 选择 g.groupId,g.name AS groupName,l.logId,l.name AS logName, i.itemID, i.name AS itemName, le.userName,completed, i. optimalMin,i.optimalMax,le.value, u.name AS unitDescription,g.parentId,g1.name AS ParentName FROM logExceptions le INNER JOIN 日志 l ON l.logID = le.logID INNER JOIN 组 g ON g.groupId = l .groupId INNER JOIN 项目 i ON le.itemId = i.itemId left JOIN groups g1 ON g.parentId = g1.groupId INNER JOIN 单位 u ON i.unitId = u.unitId