You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
12 lines
322 B
12 lines
322 B
|
|
|
|
drop proc GetShoppingCartByOrderID_Select
|
|
create proc GetShoppingCartByOrderID_Select
|
|
|
|
@OrderID int
|
|
|
|
as
|
|
|
|
|
|
select dbo.OrderDetails.ODProdID,ProdName,ProdPrice,ProdDiscount,ODProdNum, ProdDiscount*ODProdNum as price from dbo.OrderDetails,dbo.Product where OrderID=@OrderID and dbo.Product.ProdID=dbo.OrderDetails.ODProdID
|