basic join query help

[robcrozier]

Hi, i wonder if anyone could suggest how i would go about this?

 

Basically i have two tables (table1, table2).  Within table1 there is one column (ID) and within table2 there are two columns (ID, time).  The ID's reference one another too. 

 

What i'm trying to do is select all distinct ID's from table1 and then order the results by 'time' which is in table2.

 

Can anyone suggest how this can be done as i just can't get my head around it.  MySQL is not my strong point!

 

Thanks all!

[toplay]

Try something like this (untested):

 

SELECT

              DISTINCT t1.id

            , t2.`time`

  FROM

            table1 t1

  JOIN

            table2 t2

USING

            (id)

 

ORDER BY

            t2.`time`

;

 

 

or try:

 

SELECT

              t1.id

            , t2.`time`

  FROM

            table1 t1

  JOIN

            table2 t2

USING

            (id)

 

GROUP BY

            t1.id

 

ORDER BY

            t2.`time`

;