 
 
 Adel Abdallah
-Updated May 17, 2018
+Updated June 13, 2018
 
 */
 
-SELECT  DISTINCT ResourceTypeAcronymPurpose,InstanceNamePurpose ,CategoricalvaluePurpose,ResourceTypeAcronymState,InstanceNameState,CategoricalvalueState
+SELECT  DISTINCT ResourceTypeAcronymPurpose,InstanceNamePurpose ,CategoricalvaluePurpose,ResourceTypeAcronymState,InstanceNameState,FreeTextValueState
 
 FROM
 
 (
 ----------------------
 
-SELECT ResourceTypeAcronym AS ResourceTypeAcronymState,InstanceName As InstanceNameState ,Categoricalvalue As CategoricalvalueState
+SELECT ResourceTypeAcronym AS ResourceTypeAcronymState,InstanceName As InstanceNameState ,FreeTextValue As FreeTextValueState
 
 
 FROM ResourceTypes


AND ResourceTypeAcronym='US Major Dams'

AND Categoricalvalue='UT'


---------------
