具体地说运行下面的代码的得到的parent_title=null
SELECT *,(Select title Where groupid=(Select parent as newid From bagroup Where groupid=12)) as parent_title FROM bagroup WHERE groupid=12
SELECT *,(Select title Where groupid=(Select parent as newid From bagroup Where groupid=12)) as parent_title FROM bagroup WHERE groupid=12
Where groupid=' & iActiveMessageId & ' and groupid=a.parent) as parent_title
FROM bagroup a
WHERE groupid=' &iActiveMessageId'
SELECT *,(Select title From bagroup Where groupid=(Select parent From bagroup Where groupid=" & iActiveMessageId & ")) as parent_title FROM bagroup WHERE groupid=" &iActiveMessageId