How to fetch product Name using X++

EcoResProductName                       productName;
EcoResColor                             EcoResColor;
EcoResProductMaster                     EcoResProductMaster;
EcoResProductMasterColor                EcoResProductMasterColor;
EcoResProductMasterDimensionValue       EcoResProductMasterDimensionValue;
EcoResProductMasterDimValueTranslation  EcoResProductMasterDimValueTranslation;


select firstonly ProductMasterDimensionValue, Name  from EcoResProductMasterDimValueTranslation
        join RecId from EcoResProductMasterDimensionValue
             where EcoResProductMasterDimValueTranslation.ProductMasterDimensionValue   == EcoResProductMasterDimensionValue.RecId
        join RecId from EcoResProductMasterColor
            where EcoResProductMasterDimensionValue.RecId == EcoResProductMasterColor.RecId
        join RecId from EcoResColor
            where EcoResColor.RecId == EcoResProductMasterColor.Color
        join RecId from EcoResProductMaster
            where EcoResProductMasterColor.ColorProductMaster == EcoResProductMaster.RecId
            && EcoResProductMaster.DisplayProductNumber == lineEntity.ItemNumber;

        lineEntity.MCSTranslatedColorName = EcoResProductMasterDimValueTranslation.Name;