SELECT Articles.ATCID, Articles.ATAuth, Articles.ATCTitle, Articles.ATCCont, Articles.ATCClicks, Articles.ATCDate, Articles.ATCSum,
Articles.ATCType
FROM ((Articles INNER JOIN
BigTypes ON Articles.ATCType = BigTypes.TypeID) LEFT OUTER JOIN
Comments ON Articles.ATCID = Comments.AtcID)
/*-------开始-------*/
GROUP BY Articles.ATCID, Articles.ATAuth, Articles.ATCTitle, Articles.ATCCont, Articles.ATCClicks, Articles.ATCDate,
Articles.ATCSum, Articles.ATCType
/*-------结束-------*/其中ATCCont是备注类型。
注释起来的部分我添加之后 ATCCont居然会被自动截断? 谁碰到过这个问题了
Articles.ATCType
FROM ((Articles INNER JOIN
BigTypes ON Articles.ATCType = BigTypes.TypeID) LEFT OUTER JOIN
Comments ON Articles.ATCID = Comments.AtcID)
/*-------开始-------*/
GROUP BY Articles.ATCID, Articles.ATAuth, Articles.ATCTitle, Articles.ATCCont, Articles.ATCClicks, Articles.ATCDate,
Articles.ATCSum, Articles.ATCType
/*-------结束-------*/其中ATCCont是备注类型。
注释起来的部分我添加之后 ATCCont居然会被自动截断? 谁碰到过这个问题了
要用聚合函数统计回复条数,不能不用group by啊,有其他办法么?
GROUP BY Articles.ATCID, Articles.ATAuth, Articles.ATCTitle, Articles.ATCCont, Articles.ATCClicks, Articles.ATCDate,
Articles.ATCSum, Articles.ATCType在group by 后面要按这么多来分组?
Microsoft Access 数据库引擎无法对“Memo”或“OLE Object”字段进行分组。
SELECT Articles.ATCID, Articles.ATAuth, Articles.ATCTitle, Articles.ATCClicks, Articles.ATCDate, Articles.ATCSum,
Articles.ATCType,ATCCont,ATCReplys from (
SELECT Articles.ATCID, Articles.ATAuth, Articles.ATCTitle, Articles.ATCClicks, Articles.ATCDate, Articles.ATCSum,
Articles.ATCType,Count(*) as ATCReplys
FROM ((Articles INNER JOIN
BigTypes ON Articles.ATCType = BigTypes.TypeID) LEFT OUTER JOIN
Comments ON Articles.ATCID = Comments.AtcID)GROUP BY Articles.ATCID, Articles.ATAuth, Articles.ATCTitle, Articles.ATCClicks, Articles.ATCDate,
Articles.ATCSum, Articles.ATCType) as TempTb , Articles where Articles.ATCID=206 and TempTb.ATCID=Articles.ATCID
Microsoft Access 数据库引擎无法对“Memo”或“OLE Object”字段进行分组。