 LEFT JOIN "SeasonalNumericValues"
 ON "SeasonalNumericValues"."ValuesMapperID" = "ValuesMapper"."ValuesMapperID"
 
+
+LEFT JOIN FreeText
+ON FreeText.ValuesMapperID=ValuesMapper.ValuesMapperID
+
 LEFT JOIN Categoricalvalues
 ON Categoricalvalues.ValuesMapperID=ValuesMapper.ValuesMapperID
 



Adel Abdallah
Updated May 17, 2018

*/

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

FROM

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

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


FROM ResourceTypes
