John John - 1 month ago 6
PHP Question

Sort records from different tables

I have two table with an column 'minute'.
These table are joined with a INNER JOIN.
Now I want to print out all the records from both tables sorted on both the columns 'minute'

Example

Table 1: name - minute

John - 1
Marc - 3


Table 2: name - minute

Gareth - 2
Joe - 3


Output:

John, Gareth, Marc, Joe


The two tables have to remain two separate tables.

Answer

You should use UNION :-

 (SELECT  *
 FROM    table1)
    UNION 
 (SELECT  *
 FROM    table2)

 ORDER BY minute ASC

Output:-

john    1
gareth  2
marc    3
joe     3
Comments