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
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
; "" ; ""