SELECT aaa.iii, aaa.nnn, ( SELECT sum( bbb.qqq ) FROM bbb WHERE bbb.aaii = aaa.iii ) FROM aaa 你前面有表别名,到了后面from aaa的时候怎么就没有了啊
aaa是表名,呵呵. 前面也都是直接aaa.*,所以没有错误.
select aaa.nnn, sum( bbb.qqq ) as s from aaa,bbb where bbb.aiai = ( select aaa.iii from aaa)这样行不?
错误SQL 查询: 文档SELECT aaa.nnn, sum( bbb.qqq ) AS s FROM aaa, bbb WHERE bbb.aaii = ( SELECT aaa.iii FROM aaa )MySQL 返回:文档 #1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SELECT sum( bbb.qqq )
FROM bbb
WHERE bbb.aaii = aaa.iii
)
FROM aaa 你前面有表别名,到了后面from aaa的时候怎么就没有了啊
前面也都是直接aaa.*,所以没有错误.
FROM aaa, bbb
WHERE bbb.aaii = (
SELECT aaa.iii
FROM aaa )MySQL 返回:文档
#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause