博客展示了一段SQL查询代码，通过子查询从表WFTmpNodeRelation中获取RelationID、Condition，以及关联表wfnode的nodeid和childid信息，体现了SQL在数据查询方面的应用。
SELECT RelationID, Condition,
(SELECT TOP 1 a.wfnodeid
FROM wfnode a
WHERE a.nodeid = b.nodeid) AS nodeid,
(SELECT TOP 1 c.wfnodeid
FROM wfnode c
WHERE c.nodeid = b.childid) AS childid
FROM WFTmpNodeRelation b
(SELECT TOP 1 a.wfnodeid
FROM wfnode a
WHERE a.nodeid = b.nodeid) AS nodeid,
(SELECT TOP 1 c.wfnodeid
FROM wfnode c
WHERE c.nodeid = b.childid) AS childid
FROM WFTmpNodeRelation b
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
