- 论坛徽章:
- 0
|
求助:这条语句的where条件为什么无效?
表yd_ddxx(ddbh订单编号,lpmc礼品名称,lpgs礼品个数)
select "yd_ddxx"."lpmc" ,sum("yd_ddxx"."lpgs" )
FROM "yd_ddxx"
WHERE ( yd_ddxx.ddbh in ( SELECT DISTINCT "yd_ddxx"."ddbh"
FROM "yd_ddxx"
GROUP BY "yd_ddxx"."ddbh"
HAVING ( count(*) = 1 )
)) AND
( "yd_ddxx"."lpmc" in ( SELECT DISTINCT "yd_ddxx"."lpmc"
FROM "yd_ddxx"
GROUP BY "yd_ddxx"."lpmc"
HAVING ( sum("yd_ddxx"."lpgs") >= 50 )
))
group by "yd_ddxx"."lpmc"
ORDER BY "yd_ddxx"."lpmc"
ASC
;
出来的结果:
Lpmc Sum(yd Ddxx.lpgs)
actto 异型动物鼠标垫 MSP-14 -礼品 45
PUBGO 男士皮带 M91033-98710-礼品 36
奔腾 电吹风 PH1800-礼品 48
飞剑 保鲜运动水壶FJF750-015-礼品 47
飞剑350ml保温/保冷运动水壶-快乐伴侣FJT350-001-礼品 52
飞科剃须刀 FS816-礼品 68
佳康600ml保鲜水壶JKH-R90-礼品 78
卡纷炫彩毛巾一入组-礼品 36
为什么HAVING ( sum("yd_ddxx"."lpgs") >= 50 )
无效?还是出来小于50的记录了?
我的语句有什么问题? |
|