dbo.product_categories_v

Box Inc - Enterprise Data Catalog

Documentation	Products
Schema	dbo
Name	product_categories_v

Returns list of product categories with parent categories names.

Columns

		Name	Data type	Description
	1	product_category_id	int	Category ID
Category ID
	2	category_name	nvarchar(150)	Category name
Category name
	3	parent_category	nvarchar(150)	Parent category name
Parent category name

Uses

Name
dbo.product_categories_v
dbo.product_categories

Script

create view product_categories_v as SELECT b.product_category_id, b.category_name, t.category_name as parent_category FROM product_categories b left outer join product_categories t on b.product_category_id = t.parent_category_id

create view product_categories_v as
SELECT b.product_category_id, b.category_name, t.category_name as parent_category
FROM product_categories b left outer join product_categories t
on b.product_category_id = t.parent_category_id

Exported: 2019-02-04 23:17, Last imported: 2018-01-25 14:32