[SOLVED] Sort Table 1 by data in Table 2.

[phpmo]

Ok I have 2 tables.

 

Table1          Table 2

 

ID                ID

Name            T1ID

                    Age

 

I'm wanting to sort the data in Table 1 by the Age column in Table 2 and then display NAME as it appears in order of AGE.

 

In this case ID on table 1 is the same and T1ID on table 2.

 

Is there a way to do this?

[toplay]

SELECT

            t1.Name

          , t2.Age

  FROM

            Table1 t1

    JOIN

            Table2 t2

      ON

            t2.T1ID = t1.ID

 

ORDER BY

            t2.Age ASC  # or use DESC for descending

;

 

[phpmo]

worked great thanks!