mysql - 如何在sql中合并2列并排序

Question

我正在尝试对 2 个以 channel 和 View 作为列的表进行排序。我需要将 channel 和 View 合并到 2 个新列中并显示它们。

我尝试过的代码:

    SELECT IFNULL( youtube_gaming_channels_most_viewed.channel,  '' ) + 
    IFNULL( most_popular_twitch_streamers.Channel,  '' ) AS channel, 
    IFNULL( youtube_gaming_channels_most_viewed.views,  '' ) + 
    IFNULL( most_popular_twitch_streamers.Views,  '' ) AS views
    FROM youtube_gaming_channels_most_viewed
    INNER JOIN most_popular_twitch_streamers
    ORDER BY  `views` DESC 

我也尝试过 CONCAT 和 COASCE，但没有成功。

Answer 1

如果查询正常但未排序，您可以将查询用作 from 语句

select channel,views from 
(
 SELECT IFNULL( youtube_gaming_channels_most_viewed.channel,  '' ) + 
    IFNULL( most_popular_twitch_streamers.Channel,  '' ) AS channel, 
    IFNULL( youtube_gaming_channels_most_viewed.views,  '' ) + 
    IFNULL( most_popular_twitch_streamers.Views,  '' ) AS views
    FROM youtube_gaming_channels_most_viewed
    INNER JOIN most_popular_twitch_streamer
    ) v order by views DESC