Retrieve element attribute current values using Simplified Asset Database E-R Model

SELECT eh.Path + eh.Name + ea.Path + ea.Name ElementAttribute, c.*
FROM NuGreen.Asset.ElementHierarchy eh
INNER JOIN NuGreen.Asset.ElementAttribute ea ON ea.ElementID = eh.ElementID
INNER JOIN NuGreen.Data.Snapshot c ON c.ElementAttributeID = ea.ID
WHERE eh.Path LIKE N'\NuGreen\Little Rock\Extruding Process\%'
AND eh.Name LIKE N'B-%'
AND ea.Name LIKE N'%Flow'
OPTION (FORCE ORDER)