PRODUCTS

CREATE VIEW [dbo].[vProducts]

AS

SELECT Products.*, Categories.CategoryName, Suppliers.CompanyName as Supplier

FROM Products

LEFT OUTER JOIN Categories ON Categories.CategoryID = Products.CategoryID

LEFT OUTER JOIN Suppliers ON Suppliers.SupplierID = Products.SupplierID

GO

We use the vProducts view to pull the CategoryName and CompanyName for the browse mode screen below.