 
 
 
-


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


FROM ResourceTypes



Adel Abdallah
Updated May 21, 2018

*/

SELECT  DISTINCT ResourceTypeAcronymPurpose,InstanceNamePurpose CategoricalvaluePurpose,ResourceTypeAcronymState,InstanceNameState,CategoricalvalueState

FROM

(
----------------------

SELECT ResourceTypeAcronym AS ResourceTypeAcronymState,InstanceName As InstanceNameState ,Categoricalvalue As CategoricalvalueState


FROM ResourceTypes
