 
 AND (Attributes.AttributeName ='PURPOSE' or Attributes.AttributeName ='SYMBOL')
 
-AND descriptorvalue='H'
+AND Categoricalvalue='H'
 
 )
 


INNER JOIN
(
SELECT ResourceTypeAcronym AS ResourceTypeAcronymPurpose,InstanceName As InstanceNamePurpose ,descriptorvalue As DescriptorValuePurpose


FROM ResourceTypes


AND ResourceTypeAcronym='US Major Dams'

AND Categoricalvalue='CA'


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