mysql并排合并查询结果 [英] mysql combine query results side by side

问题描述

一个简单的问题，我无法理解. 我只想并排合并两个没有共同数据的表.

Simple question that I cant get my head around. I want to just combine two tables with no common data side by side.

table1    table2   ->   result 
a  b       e  f          a  b  e  f
c  d       g  h          c  d  g  h
           i  j          \n \n i  j

推荐答案

您可以使用RIGHT JOIN进行此操作，并使用ROW_NUMBER为每个表分配一个ID.请参阅下面的查询:

You can do this using RIGHT JOIN and assign an id to each of your tables using ROW_NUMBER. See my query below:

 SELECT A.column1,A.column2,B.column1,B.column2 FROM
    (SELECT
         @row_number1:=@row_number1+1 AS RowNumber1,
         column1,
         column2
    FROM Table1, (SELECT @row_number1:=0)AS x ORDER BY column1) AS A
    RIGHT JOIN
    (SELECT
         @row_number2:=@row_number2+1 AS RowNumber2,
         column1,
         column2
    FROM Table2, (SELECT @row_number2:=0)AS y ORDER BY column1) AS B
    ON A.RowNumber1=B.RowNumber2

这篇关于mysql并排合并查询结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！