PDA

View Full Version : Solved: Specific Order?



lienlee
06-07-2010, 11:30 AM
Domain....... | Area
Supply Chain Inventory
Supply Chain Lead Time
Supply Chain Purchase Orders
Supply Chain Shipments
Supply Chain Store Order
Supply Chain Transportation
Supply Chain Warehouse Logistics
Retail Sales Sales Support
Offering Costing
Offering Part
Offering Pricing
Offering Product
Offering Product Lifecycle
Offering Services
Is it possible to group by a specific order?..for example
i want to group by a specific Domain, Supply first then Retail. and for supply chain..its purchase order first then store number

from my knowledge you can only order by columns, desc. etc. but you cant choose which specific order.



Note: this output is from a query i have. if it'll help

SELECT Subject_Domain.Subject_Domain_Name, Subject_Area.Subject_Area_Name, Count(Subject_Area.Subject_Area_Name) AS NumberofCurrentDataModels
FROM Data_Model, Subject_Domain INNER JOIN (Subject_Area INNER JOIN Conceptual_Entity ON Subject_Area.Subject_Area_ID = Conceptual_Entity.Subject_Area_ID) ON Subject_Domain.Subject_Domain_ID = Subject_Area.Subject_Domain_ID
WHERE (((Data_Model.Data_Model_Name)='EADM10_UA'))
GROUP BY Subject_Domain.Subject_Domain_Name, Subject_Area.Subject_Area_Name, Data_Model.Data_Model_Name;

stanl
06-08-2010, 03:21 AM
without having real data to play with my best guess is you can group by the major categories then use a HAVING clause with a sub-select query. .02 Stan

lienlee
06-08-2010, 04:30 PM
I'm not sure if im making myself clear or not, but i'll try to explain again.
I'll use supply chain as the example.

Supply Chain Inventory
Supply Chain Lead Time
Supply Chain Purchase Orders
Supply Chain Shipments
Supply Chain Store Order
Supply Chain Transportation
Supply Chain Warehouse Logistics

supply chain is subject domain
inventory, lead time etc, are subject area. is there a way to order that i can choose to have store order first, then inventory. etc?

assume that all this is from one table.