select quiery problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • batman007
    New Member
    • Nov 2009
    • 3

    select quiery problem

    programmingiBut ton

    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
    Hi I want to select ibuttonid,date , time columns from both tables and order
    by date, time groupby loggerid
  • code green
    Recognized Expert Top Contributor
    • Mar 2007
    • 1726

    #2
    You have as good as written the query in pseudo code.
    What is the problem?

    Comment

    Working...