mysql as不能用吗,MySQL SUM不能与AS一起工作

我有这3个表my_stamp，my_invoice和邮票

现在我想从邮票表中获得价格的总和。

这里是我现在的SQL查询。

$sql= "SELECT s.country, s.stamp_no, s.year, s.sgno, s.condition, SUM(ssk.price) as psum ";

$sql_cnt = "SELECT s.stamp_no AS num ";

$frm = "FROM stamp AS ssk ,my_stamp AS s, my_invoice AS sk ";

$filter = "WHERE s.invoice_id=sk.invoice_id AND ssk.stamp_no=s.stamp_no AND sk.cusid='" . $usr . "'";

$sql_cnt = $sql_cnt . $frm . $filter. " Group by s.stamp_no";查询工作正常。我的主要问题是psum没有获得总价。

当我通过结果循环获得单个价格。

有人可以帮助我在这个SUM在MySQL？

谢谢。

编辑::这里是我得到的最终的SQL：

SELECT s.country, s.stamp_no, s.year, s.sgno, s.condition, SUM(ssk.price) as psum FROM stamp AS ssk ,my_stamp AS s, my_invoice AS sk WHERE s.invoice_id=sk.invoice_id AND ssk.stamp_no=s.stamp_no AND sk.cusid='10' Group by s.stamp_no ORDER BY s.country, s.sgno ASC LIMIT 0,20