 6.MeasureStorageSavings.sql
 
 Adel Abdallah
-October 30, 2017
+Jan 27, 2018
 
 
 

LEFT JOIN  "Attributes"
ON "Attributes"."ObjectTypeID"="ObjectTypes"."ObjectTypeID"

LEFT JOIN "Mapping"
ON "Mapping"."AttributeID"= "Attributes"."AttributeID"

LEFT JOIN "Instances" 
ON "Instances"."InstanceID"="Mapping"."InstanceID"

LEFT JOIN "ScenarioMapping"
ON "ScenarioMapping"."MappingID"="Mapping"."MappingID"

LEFT JOIN "Scenarios" 
ON "Scenarios"."ScenarioID"="ScenarioMapping"."ScenarioID"

LEFT JOIN "MasterNetworks" 
ON "MasterNetworks"."MasterNetworkID"="Scenarios"."MasterNetworkID"

*/


SELECT DISTINCT "Mappings"."MappingID",DatasetAcronym,ScenarioName,ObjectType,AttributeName,AttributeNameCV,
InstanceName,InstanceNameCV
--SELECT ScenarioName,ScenarioMappingID

