正文
ACCESS 组合字段 order by 出错
提示：扫一扫查出行【扫一扫了解最新限行尾号】
复制提示
ACCESS 组合字段 order by 出错
SELECT boardID,boardType,parentID,child,depth,rootID,(parentStr + ',' + boardID) AS parentStr_order FROM comp_Type ORDER BY rootID,(parentStr + ',' + boardID)
or
SELECT boardID,boardType,parentID,child,depth,rootID,(parentStr + ',' + boardID) AS parentStr_order
FROM comp_Type
