34,576
社区成员
发帖
与我相关
我的任务
分享
declare @p as nvarchar(10)
select @p =N'物品1'
select @p as 物品名称,sum(金额) as 金额
from a
join b on a.料号 =b.料号 and b.物品名称=@p
select b.物品名称,
sum(金额)金额
from ta a,
tb b
where a.料号=b.料号
group by
b.物品名称
declare @p as nvarchar(10)
select @p =N'物品1'
select @p as b.物品名称,sum(金额) as 金额
from a
join b on a.料号 =b.料号 b.物品名称=@p
select b.物品名称,
sum(金额)金额
from ta a,tb b
where a.料号=b.料号
group by b.物品名称
select b.物品名称,sum(金额) as 金额
from a
join b on a.料号 =b.料号
group by b.物品名称