programmingiBut ton
ReadingiButton
readingiButton
Hi I want to select ibuttonid,date , time columns from both tables and order
by date, time groupby loggerid
Code:
loggerid ibuttonid date time samplerate
1 337-9732000-1 2009-06-18 21:15:57 1
2 33-4-1832000 2009-06-18 21:16:38 1
3 33-124123300 2009-06-18 21:17:06 1
4 337-9732000-1 2009-06-18 22:45:45 1
5 33-4-1832000 2009-06-18 22:46:02 1
ReadingiButton
readingiButton
Code:
loggerid ibuttonid date time samplerate temp_logger
1 337-9732000 2009-06-18 21:40:00 1 27,26
2 33-4-1832000 2009-06-18 21:41:21 1 28,26
by date, time groupby loggerid
Comment