SQL存储过程 明细表信息-扣率
create proc Get_DiscountDetial
@DiscountCode nvarchar(100)
as
begin
SELECT
Goods_Type.TypeCode TypeCode,
Goods_Type.TypeName TypeName,
SettleAccounts_DiscountList.Rebate Rebate
FROM
Goods_Type INNER JOIN
SettleAccounts_DiscountList ON Goods_Type.TypeCode = SettleAccounts_DiscountList.TypeCode
where SettleAccounts_DiscountList.DiscountCode=@DiscountCode
end