发布网友
共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