select a.品牌,a.克数,sum(数量和), 最小单价,b.供应商 from 纸张库存表 a,
(select 供应商, 品牌,min([单价(元)]) 最小单价 from 纸张库存表 group by 供应商, 品牌 ) as b
where a.供应商=b.供应商 and a.品牌.b,品牌 and a.[单价(元)] =最小单价
(select 供应商, 品牌,min([单价(元)]) 最小单价 from 纸张库存表 group by 供应商, 品牌 ) as b
where a.供应商=b.供应商 and a.品牌.b,品牌 and a.[单价(元)] =最小单价
(select 供应商, 品牌,min([单价(元)]) 最小单价 from 纸张库存表 group by 供应商, 品牌 ) as b
where a.供应商=b.供应商 and a.品牌.b,品牌 and a.[单价(元)] =最小单价
group by a.品牌,a.克数,最小单价,b.供应商
(select 供应商, 品牌,min([单价(元)]) 最小单价 from 纸张库存表 group by 供应商, 品牌 ) as b
where a.供应商=b.供应商 and a.品牌=b,品牌 and a.[单价(元)] =最小单价
group by a.品牌,a.克数,最小单价,b.供应商
(select sum([数量(令)]) as 数量和,min([单价(元)]) as 最小单价,品牌,克数 from 纸张库存表 group by 品牌,克数) as a,
(select 品牌,克重,数量 as 预警数量 from 纸张预警表) as b
where a.品牌=b.品牌 and a.克数=b.克重 and a.数量和<=b.预警数量按照上面这么写是正确的,但是怎么返回纸张库存表的供应商呢
(select sum([数量(令)]) as 数量和,min([单价(元)]) as 最小单价,品牌,克数 from 纸张库存表 group by 品牌,克数) as a,
(select 品牌,克重,数量 as 预警数量 from 纸张预警表) as b,
纸张库存表 c
where a.品牌=b.品牌 and a.克数=b.克重 and a.数量和<=b.预警数量
(select sum([数量(令)]) as 数量和,min([单价(元)]) as 最小单价,品牌,克数 from 纸张库存表 group by 品牌,克数) as a,
(select 品牌,克重,数量 as 预警数量 from 纸张预警表) as b,
纸张库存表 c
where a.品牌=b.品牌 and a.克数=b.克重 and a.数量和<=b.预警数量 and a.品牌=c.品牌 and a.克数=c.克数 and a.最小单价=c.[单价(元)]
上面这么写能返回正确结果。但是有没有简单一点的
我总决的我写的太麻烦了