CODEWITHSUNDEEP
phpmysqlsqlsql-serversqlite
Plic Pl
Plic Pl

Reputation: 541

Merge results from two different tables with different column number, ORDER them by same key

I have two tables:

Table A: ID Cars Planes Num
          1    3      5   2
          2    8      44  1
          3    7      23  6
          4    6      2   7

Table B: ID Horses Dogs Cats Elefants Num
          1    3      5   2      3     3  
          2    8      44  1     22     4
          3    7      23  4     14     8
          4    6      2   3     15     5

What I need to do: I need to get all results from both tables and sort them by the "Num" Column, where the "number" actually is unique for each result from both rows.

Is it even possible to "merge" those two tables and order them by "num" or should I just get each table separately ordered and do two loops checking always for the next num jumping between tables?

Thanks

Upvotes: 0

Views: 87

Answers (2)

M.Ali
M.Ali

Reputation: 69494

SELECT NUM FROM TABLEA
UNION ALL
SELECT NUM FROM TABLEB
ORDER BY 1

Upvotes: 0

echo_Me
echo_Me

Reputation: 37233

you can merge them like that with UNION .

try this:

select num from(
    select num from table1
    union all
    select num from table2
    )t
order by num asc

DEMO HERE

EDIT:

select id ,Cars,Planes, Horses,Dogs,Cats,Elefants,num from(
    select id ,Cars,Planes,'No horses' Horses,'No dogs' Dogs,'No cats' Cats,'No elefants' Elefants,num from table1
union all
select id,'No cars' Cars,'No planes' Planes,Horses,dogs,Cats,Elefants, num from table2
 )t
 order by num asc;

DEmo with other columns

Upvotes: 2

Related Questions