Retrieve element attributes and optional UOM

SELECT eh.Path + eh.Name Element, ea.Path + ea.Name ElementAttribute, uom.Name
FROM NuGreen.Asset.ElementHierarchy eh
INNER JOIN NuGreen.Asset.ElementAttribute ea ON ea.ElementID = eh.ElementID
LEFT OUTER JOIN System.UnitOfMeasure.UOM uom ON uom.ID = ea.DefaultUOMID
WHERE eh.Path = N'\NuGreen\Houston\Cracking Process\Equipment\'
OPTION (FORCE ORDER)