Merge 2 different tables and display content sorting by number of views (larger to smaller) of the two joints in Mysql

Question

Merge 2 different tables and display content sorting by number of views (larger to smaller) of the two joints in Mysql

Asked 8 years, 10 months ago

Viewed 99 times

4

Whereas I have 2 tables in the comic, "news" and "news", each with its own fields:

It is possible to make a SELECT in both tables at the same time so that I return the 4 highest values of the "printed" fields (table NOTICIAS) and "clicks" (table NOVIDADES), the two combined?

The expected result would be this (ordering from highest to lowest):

Wrong (15 views)
Hello (9 views)
Medium (6 views)
Good (5 views)

Tables have no foreign key relation??

– user28595

2015/12/30 at 20:37
@Diegofelipe I’m sorry, but I don’t understand your question.

– Sam

2015/12/30 at 20:39
the news id is the same news id?

– Marllon Nasser

2015/12/30 at 20:40
If there is any link between the tables, if one has a key field of the other.

– user28595

2015/12/30 at 20:41
@Marllonnasser The tables have their own Ids and one has no relation to the other.

– Sam

2015/12/30 at 20:45

1 answer

Browser other questions tagged mysql

You are not signed in. Login or sign up in order to post.

by Marllon Nasser • **3,845** points · Answer 1 · 2015-12-30T21:00:45+00:00

4

select * from 
(select titulo, impressoes as visualizacoes
from 
noticias 
union ALL
select titulo, cliques as visualizacoes
from cliques) result order by result.visualizacoes desc
limit 0,4

Upshot:

Fiddle

He only wants the big four, I think a simple addition to his code with limit 1,4 resolve.

– user28595

2015/12/30 at 21:03
limit 0,4. I edited :)

– Marllon Nasser

2015/12/30 at 21:09
It’s true, 0.4 kkk

– user28595

2015/12/30 at 21:10
@Marllonnasser It worked perfectly! Mt thank you!

– Sam

2015/12/30 at 21:14