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;
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;