SQL分组统计且跨表查询
发布网友
共4个回答
热心网友
SELECT Table2.t_name,sum(Table1.s_total) FROM Table1,Table2 WHERE Table1.s_date LIKE '2013-02-__' GROUP BY Table2.t_name
SELECT Table2.t_id,sum(Table1.s_total) FROM Table1,Table2 WHERE Table1.s_date LIKE '2013-02-__' GROUP BY Table2.t_id
SELECT Table2.t_id,Table2.t_name,sum(Table1.s_total) FROM Table1,Table2 WHERE Table1.s_date LIKE '2013-02-__' GROUP BY Table2.t_id,Table2.t_name
group by 至少要包括除了函数之外的所有SELECT的字段
热心网友
SELECT Table2.t_name,sum(Table1.s_total) FROM Table1,Table2 WHERE Table1.s_date LIKE '2013-02-__' GROUP BY Table2.t_name
这样就对了，你要group by 你查询的字段名追问你有没有试过，我试过了，不行，select出来的结果会把我不要的结果都列出来，而且数据也都错了，求助啊
追答SELECT Table2.t_name,count(Table1.s_total) FROM Table1,Table2 WHERE Table1.s_date LIKE '2013-02-__' GROUP BY Table2.t_name
把SUM改成COUNT试试。
热心网友
SELECT
TABLE1.T_ID,
TABLE2.T_NAME,
SUM(TABLE1.S_TOTAL)
FROM TABLE2,TABLE1
WHERE
TABLE1.T_ID=TABLE2.T_ID AND TABLE1.S_DATE LIKE '2013-02-__'
GROUP BY TABLE1.T_ID,TABLE2.T_NAME
热心网友
SELECT Table2.t_name,sum(Table1.s_total) FROM Table1,Table2 WHERE Table1.s_date LIKE '2013-02-__' GROUP BY Table2.t_name
