Ordering results by values in other table

Question

I have two tables :

               Table1

    id  |  name  |  age |  d_o_b  
=====================================
    1   |  ASD   |  22  |  12/01/1992  
    2   |  QWE   |  21  |  04/04/1993  
    3   |  FRG   |  24  |  04/04/1990


   Table2

    id  |  age
===============
    1   |  22  
    2   |  21
    3   |  24

Is it possible to order by two columns one from first Table1 and then by one column from Table2.

Something like ..

SELECT * FROM Table1 order by d_o_b , age in (SELECT * FROM Table2)

Not sure whats your problem but you have age in table1 why don't you use that in order by — Pரதீப், Jan 25 '15 at 10:53
possible duplicate of [SQL multiple column ordering](http://stackoverflow.com/questions/2051162/sql-multiple-column-ordering) — Bowdzone, Jan 25 '15 at 10:56
Edit your question and show the results that you want. `d_o_b` is unique in the first table, so an additional `order by` key is unnecessary. — Gordon Linoff, Jan 25 '15 at 16:24

Jayvee · Answer 1 · 2015-01-25T11:19:09.847

1

To order by a column in other table you may need to join them. This should work:

SELECT a.* FROM Table1 a
join table2 b
on a.id=b.id
order by d_o_b,b.age

edited Jan 25 '15 at 11:19

answered Jan 25 '15 at 10:55

Jayvee

10,670
3
29
40

1

This does provide the answer to the question. – Whirl Mind Jan 25 '15 at 12:20
`order by age` gives the result in ascending order of age.....but what I need is the result in the order of age which is present in `Table2` – Deepak Sharma Jan 27 '15 at 16:01
that's why the order clause is "b.age" , b is table2 alias so b.age is the age in table2 – Jayvee Jan 27 '15 at 16:04

Ordering results by values in other table

1 Answers1