dimensiones1.sql

SELECT
  ProductID,
  Product.Name Product,
  ProductCategory.name ProductCategory,
  ProductSubCategory.name ProductSubCategory,
  ProductNumber,
  ProductModel.name ProductModel,
  Color,
  StandardCost,
  ListPrice,
  Size,
  SizeUnitMeasureCode,
  Weight,
  WeightUnitMeasureCode,
  ProductLine,
  DiscontinuedDate,
  MakeFlag,
  FinishedGoodsFlag
FROM staging.Product
LEFT JOIN staging.ProductSubCategory ON Product.ProductSubcategoryID=ProductSubCategory.ProductSubcategoryID
LEFT JOIN staging.ProductCategory ON ProductSubCategory.ProductCategoryId=ProductCategory.ProductCategoryId
LEFT JOIN staging.ProductModel ON Product.ProductModelID=ProductModel.ProductModelID