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 ORDER BY rootID,7

ACCESS 组合字段 order by 出错

原文：http://www.cnblogs.com/lbnnbs/p/4781521.html