AdventureWorks2012 - Sales Order Detail Query

Every time we used to join different tables to get complete Sales information. 

The below query returns complete sale order details based on below tables

Sales.SalesOrderDetail. 

Production.Product

Production.ProductCategory

Sales.SalesTerritory

Person.CountryRegion

SELECT PC.Name AS Category ,SC.Name AS SubCategory ,P.Name AS Product ,SO.SalesOrderID ,SO.UnitPrice ,SO.LineTotal ,SO.OrderQty ,SOH.OrderDate ,CR.Name AS CountryOrRegion ,ST.[Group] AS Region FROM Sales.SalesOrderDetail AS SO LEFT OUTER JOIN Sales.SalesOrderHeader AS SOH ON SOH.SalesOrderID = SO.SalesOrderID LEFT OUTER JOIN Production.Product AS P ON P.ProductID = SO.ProductID LEFT OUTER JOIN Production.ProductSubcategory AS SC ON SC.ProductSubcategoryID = P.ProductSubcategoryID LEFT OUTER JOIN Production.ProductCategory AS PC ON PC.ProductCategoryID = SC.ProductCategoryID LEFT OUTER JOIN Sales.SalesTerritory AS ST ON ST.TerritoryID = SOH.TerritoryID LEFT OUTER JOIN Person.CountryRegion AS CR ON CR.CountryRegionCode = ST.CountryRegionCode