AnsweredAssumed Answered

eSQL Structure Question

Question asked by dig on Nov 3, 2017
Latest reply on Nov 4, 2017 by philmodjunk

Hi All - Looking for some feed back on this query, I just taught myself how to do it and before I start using it in my new solution and saving it in my tools I thought it best to see if there was anything I should/could do better in it syntax wise etc.

 

I am trying to reduce the amount of TO's I use and instead use eSQL Joins as a first choice wherever possible/practical

 

ExecuteSQL (

"

SELECT ( \"currentReading\" )

FROM  \"ReadingMeter\" AS rm , \"Equipment\" as eq

WHERE rm.id_Equipment = eq.id

ORDER BY rm.zzCreationTimestamp DESC

FETCH FIRST 1 ROW ONLY

"

; "" ; ""

)

 

Thanks

Outcomes