Production.vProductAndDescription View

Information

NamevProductAndDescription
SchemaProduction
Created29.3.2010. 21:58:56
Modified29.3.2010. 21:58:56

SQL Script

CREATE VIEW [Production].[vProductAndDescription] 
WITH SCHEMABINDING 
AS 
SELECT 
p.[ProductID] 
,p.[Name] 
,pm.[Name] AS [ProductModel] 
,pmx.[CultureID] 
,pd.[Description] 
FROM [Production].[Product] p 
INNER JOIN [Production].[ProductModel] pm 
ON p.[ProductModelID] = pm.[ProductModelID] 
INNER JOIN [Production].[ProductModelProductDescriptionCulture] pmx 
ON pm.[ProductModelID] = pmx.[ProductModelID] 
INNER JOIN [Production].[ProductDescription] pd 
ON pmx.[ProductDescriptionID] = pd.[ProductDescriptionID];