Wednesday 9 October 2013

13. Create a view to retrieve SalesOrderId and Price of the Product along with the corresponding Product Name.

create View vwsales
as
select P.Name, S.SalesOrderID,S.UnitPrice
from Production.Product P inner join
Sales.SalesOrderDetail S
on P.ProductID = ProductID
go

No comments:

Post a Comment