Select distinct count(CKGL_PMB.hwgg) from CKGL_KCB inner join CKGL_PMB on CKGL_KCB.hwid=CKGL_PMB.hwid where CKGL_KCB.ztbz='正常' order by CKGL_KCB.ckmc
select hwlb from PMB where hwid in (select hwid from (Select CKGL_KCB.ckmc as 仓库名称,CKGL_KCB.kcsl as 数量,CKGL_KCB.kcdj as 库存单价, CKGL_KCB.kcje as 库存金额,CKGL_PMB.hwlb as 货物类别,CKGL_PMB.hwdm as 货物代码, CKGL_PMB.hwmc as 货物名称,CKGL_PMB.hwgg as 货物规格,CKGL_PMB.jldw as 单位 ,CKGL_PMB.hwid from CKGL_KCB inner join CKGL_PMB on CKGL_KCB.hwid=CKGL_PMB.hwid where CKGL_KCB.ztbz='正常' order by CKGL_KCB.ckmc) ) group by hwlb
please try... select hwlb from PMB where hwid in (select hwid from (Select CKGL_KCB.ckmc as 仓库名称,CKGL_KCB.kcsl as 数量,CKGL_KCB.kcdj as 库存单价, CKGL_KCB.kcje as 库存金额,CKGL_PMB.hwlb as 货物类别,CKGL_PMB.hwdm as 货物代码, CKGL_PMB.hwmc as 货物名称,CKGL_PMB.hwgg as 货物规格,CKGL_PMB.jldw as 单位 ,CKGL_PMB.hwid from CKGL_KCB inner join CKGL_PMB on CKGL_KCB.hwid=CKGL_PMB.hwid where CKGL_KCB.ztbz='正常' order by CKGL_KCB.ckmc) ) group by hwlb
Select B.hwgg as 货物规格,count(*) 數量 from CKGL_KCB A inner join CKGL_PMB B on A.hwid=B.hwid where A.ztbz='正常' Group by B.hwgg
from CKGL_KCB inner join CKGL_PMB on CKGL_KCB.hwid=CKGL_PMB.hwid
where CKGL_KCB.ztbz='正常' order by CKGL_KCB.ckmc
CKGL_KCB.kcje as 库存金额,CKGL_PMB.hwlb as 货物类别,CKGL_PMB.hwdm as 货物代码,
CKGL_PMB.hwmc as 货物名称,CKGL_PMB.hwgg as 货物规格,CKGL_PMB.jldw as 单位 ,CKGL_PMB.hwid
from CKGL_KCB inner join CKGL_PMB on CKGL_KCB.hwid=CKGL_PMB.hwid
where CKGL_KCB.ztbz='正常' order by CKGL_KCB.ckmc) )
group by hwlb
select hwlb from PMB where hwid in (select hwid from (Select CKGL_KCB.ckmc as 仓库名称,CKGL_KCB.kcsl as 数量,CKGL_KCB.kcdj as 库存单价,
CKGL_KCB.kcje as 库存金额,CKGL_PMB.hwlb as 货物类别,CKGL_PMB.hwdm as 货物代码,
CKGL_PMB.hwmc as 货物名称,CKGL_PMB.hwgg as 货物规格,CKGL_PMB.jldw as 单位 ,CKGL_PMB.hwid
from CKGL_KCB inner join CKGL_PMB on CKGL_KCB.hwid=CKGL_PMB.hwid
where CKGL_KCB.ztbz='正常' order by CKGL_KCB.ckmc) )
group by hwlb
on A.hwid=B.hwid where A.ztbz='正常' Group by B.hwgg