Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Q6 Podaj produkty, które nie zostały kupione przez żadnego klienta. Zestawienie pogrupuj według kategorii.
- -- Czemu jak robię FULL JOIN to mi nie chce sortować kategorii?
- -- MOJE
- SELECT Production.Product.ProductID, Production.Product.Name AS product, Production.ProductCategory.Name AS category
- FROM Production.Product
- JOIN Production.ProductSubcategory ON Product.ProductSubcategoryID = Production.ProductSubcategory.ProductSubcategoryID
- JOIN Production.ProductCategory ON Production.ProductSubcategory.ProductCategoryID = Production.ProductCategory.ProductCategoryID
- FULL OUTER JOIN Sales.SalesOrderDetail ON Production.Product.ProductID = Sales.SalesOrderDetail.ProductID
- FULL OUTER JOIN Sales.SalesOrderHeader ON Sales.SalesOrderDetail.SalesOrderID = Sales.SalesOrderHeader.SalesOrderID
- FULL OUTER JOIN Sales.Customer ON Sales.SalesOrderHeader.CustomerID = Sales.Customer.CustomerID
- WHERE Sales.Customer.CustomerID IS NULL
- GROUP BY Production.ProductCategory.Name, Production.Product.Name, Production.Product.ProductID;
- -- TWOJE
- SELECT Production.Product.ProductID, Production.Product.Name AS product_name, Production.ProductCategory.Name AS category_name
- FROM Production.Product
- JOIN Production.ProductSubcategory ON Product.ProductSubcategoryID = Production.ProductSubcategory.ProductSubcategoryID
- JOIN Production.ProductCategory ON Production.ProductSubcategory.ProductCategoryID = Production.ProductCategory.ProductCategoryID
- LEFT JOIN Sales.SalesOrderDetail ON Production.Product.ProductID = Sales.SalesOrderDetail.ProductID
- LEFT JOIN Sales.SalesOrderHeader ON Sales.SalesOrderDetail.SalesOrderID = Sales.SalesOrderHeader.SalesOrderID
- LEFT JOIN Sales.Customer ON Sales.SalesOrderHeader.CustomerID = Sales.Customer.CustomerID
- WHERE Sales.Customer.CustomerID IS NULL
- GROUP BY Production.ProductCategory.Name, Production.Product.Name, Production.Product.ProductID;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement