Query to show Category, Sub category and Item (MSSQL & PGSQL)

Query to show Category, Sub category and Item (MSSQL & PGSQL)

Tested in Build PGSQL (14300) or MSSQL (14306)

PGSQL & MSSQL:

Excute the below query under  Report > New Report > Query Report > Copy, Paste the below and Run the query. 

SELECT CategoryDefinition.CATEGORYNAME "Category Name", CategoryDefinition.CATEGORYNAME "Category Name", SubCategoryDefinition.NAME "Sub Category Name" ,ItemDefinition.NAME"Item Name" FROM CategoryDefinition left join SubCategoryDefinition on  SubCategoryDefinition.CATEGORYID=CategoryDefinition.CATEGORYID  left join ItemDefinition on ItemDefinition.SUBCATEGORYID = SubCategoryDefinition.SUBCATEGORYID group by CategoryDefinition.CATEGORYNAME,SubCategoryDefinition.NAME,ItemDefinition.NAME order by CategoryDefinition.CATEGORYNAME