--TRY
CREATE PROCEDURE DeployDetails_SelectById
@id int
AS
BEGIN
select * from item i inner join DeployDetails d on i.itemid=d.ItemId and d.id=@id
END
GO
CREATE PROCEDURE DeployDetails_SelectById
@id int
AS
BEGIN
select * from item i inner join DeployDetails d on i.itemid=d.ItemId and d.id=@id
END
GO
-- =============================================
-- Author: 牛腩
-- Create date: 2008-10-13 11:04
-- Description: 根据配置ID查看配置明细
-- =============================================
ALTER PROCEDURE [dbo].[DeployDetails_SelectById]
@id int
AS
BEGINSELECT Product.Name AS 类别, Brand.Name AS 品牌, Item.xh AS 型号,
DeployDetails.Quantity AS 数量, CO.UnitCost AS 批价,DeployDetails.ItemId
FROM DeployDetails
INNER JOIN Item ON DeployDetails.ItemId = Item.ItemId
INNER JOIN Brand ON Item.BrandId = Brand.BrandId
INNER JOIN Product ON Item.ProductId = Product.ProductId
INNER JOIN CO ON Item.ItemId = CO.ItemId
and CO.CoId in (select min(CoId) from CO group by CO.ItemId )END