SELECT
COUNT(distinct a.productid),
SUM(a.number) AS asum,
a.productid AS aproductid,
a.warehouseid AS awarehouseid,
a.number AS anumber,
b.alarm AS balarm,
a.price AS aprice,
b.unit AS bunit
FROM {$tablepre}stocksalesdate AS a,{$tablepre}productbasic AS b
WHERE a.productid=b.productbasicid and a.type!=2 and b.alarm>=a.asum
GROUP BY a.productid ORDER BY a.datetime desc
LIMIT ".$offset.",".$psize."
COUNT(distinct a.productid),
SUM(a.number) AS asum,
a.productid AS aproductid,
a.warehouseid AS awarehouseid,
a.number AS anumber,
b.alarm AS balarm,
a.price AS aprice,
b.unit AS bunit
FROM {$tablepre}stocksalesdate AS a,{$tablepre}productbasic AS b
WHERE a.productid=b.productbasicid and a.type!=2 and b.alarm>=a.asum
GROUP BY a.productid ORDER BY a.datetime desc
LIMIT ".$offset.",".$psize."
解决方案 »
- PAYPAL的sandbox帐号被锁定问题
- smarty问题,请教
- PHP可选字段的导出。。。。
- 不是说安装zend optimizer 速度能提上去嘛?
- 为什么HTTP/1.1和HTTP/1.0的返回值不一样啊?
- 请教一个奇怪的php环境安装问题,困扰了我很长时间,很急……
- 用APACHE配置多站点,能不能分别设置每个站点需要预加载的文件?
- 请问:如何用PHP做一个网络会议室(语音版)<20分,在线等待......>
- 求救~~~~~~~~为什么cpu的使用达到95%-100%?我出50分~~求救!
- 如何恢复win2k server的注册表?
- 一个仿WINDOWS登陆窗口,用PHP写的,不知道是什么技术
- 视频播放的限制 。。。。
select COUNT(distinct a.productid),SUM(a.number) AS asum,a.productid AS aproductid,
a.warehouseid AS awarehouseid,
a.number AS anumber,b.alarm AS balarm,a.price AS aprice,b.unit AS bunit
from stocksalesdate a, productbasic b
where a.productid=b.productbasicid and a.type!=2
GROUP BY a.productid
having sum(a.number)<=sum(b.alarm)/count(b.alarm)
看来,我对SQL语句,了解的还是不够深啊、!!!!!!!!!给分加分!!!