select a.username, a.user_id, sum(b.) as , count(b.) as count from a inner join b on a.user_id = b.user_id group by a.username, a.user_id
顺便请教一下 bzszp(www.bzszp.533.net) , 有时候会遇到“未找到预期的FROM关键字” 或者是“缺少表达式”样的错误 语句看上去好像也没有这么明显的错误,为什么会这样的?就比如说 select a.username,a.userid,=(select sum() from 表b where user_id=a.userid),[count]=(select count(*) from 表b where user_id=a.userid) from 表a a 运行后说找不到from关键字select a.username,a.userid,[]=(select sum() from 表b where user_id=a.userid),[count]=(select count(*) from 表b where user_id=a.userid) from 表a a 运行后说缺少表达式能够帮我分析一下么?谢谢
用一种新的写法: with bb as (select user_id,sum() sm,count() cm from b group by user_id) select a.username,bb.* from a,bb where a.user_id=bb.user_id
from a inner join b on a.user_id = b.user_id
group by a.username, a.user_id
有时候会遇到“未找到预期的FROM关键字”
或者是“缺少表达式”样的错误
语句看上去好像也没有这么明显的错误,为什么会这样的?就比如说
select a.username,a.userid,=(select sum() from 表b where user_id=a.userid),[count]=(select count(*) from 表b where user_id=a.userid) from 表a a
运行后说找不到from关键字select a.username,a.userid,[]=(select sum() from 表b where user_id=a.userid),[count]=(select count(*) from 表b where user_id=a.userid) from 表a a
运行后说缺少表达式能够帮我分析一下么?谢谢
with bb as
(select user_id,sum() sm,count() cm from b group by user_id)
select a.username,bb.* from a,bb where a.user_id=bb.user_id