1,217
社区成员
![](https://csdnimg.cn/release/cmsfe/public/img/topic.427195d5.png)
![](https://csdnimg.cn/release/cmsfe/public/img/me.40a70ab0.png)
![](https://csdnimg.cn/release/cmsfe/public/img/task.87b52881.png)
![](https://csdnimg.cn/release/cmsfe/public/img/share-circle.3e0b7822.png)
select strName from tblNode.strDetailTable where lngId = tblNode.lngDetailid
SELECT N.lngNodeID, D.strName
FROM tblNode N
JOIN ( SELECT lngID, strName, 'action' AS DetailType FROM action
UNION ALL
SELECT lngID, strName, 'project' AS DetailType FROM project
UNION ALL
SELECT lngID, strName, 'logItem' AS DetailType FROM logItem
) D
ON D.lngID = N.lngDetailID
AND D.DetailType = N.strDetailTable
select strName
from (select strDetailTable from tblNode)
where lngId = (select lngDetailid from tblNode)