George Thompson
Asrujit SenGupta
It works guys!
thank you!!!!
I added some new fields, also the shape so it will show the geometry, and the symbology works.
Another question if I may, I am sorry to stress out too much:
The query that works is this one:
SELECT b.objectid, b.globalid, b.shortname, b.longname, b.shape, r.timestamp, r.room, r.acmode, r.actemp
FROM BLKJ_Building b, Readings r
WHERE b.shortname = r.room
I would like to select the last time stamp only and a range. (the range ideally for a time slider)
for last time stamp I've tried this one, but doesn't work.
Any idea of what should be the correct one?
SELECT b.objectid, b.globalid, b.shortname, b.longname, b.floor, b.shape, MAX(r.timestamp), r.room, r.acmode, r.actemp
FROM Building b, Readings r
WHERE b.shortname = r.room