一张表数据环比数据【挪列对比】,如需要其他条件可以在两个子查询中再另外加上需要添加的条件即可
SELECT
p3.column,p4.column
FROM
(
SELECT
*,(@i := @i + 1 ) num
FROM
tableA,(
SELECT
@i := 0
) AS a
) AS p3
INNER JOIN (
SELECT
*,(@m := @m + 1 ) num
FROM
tableB,(
SELECT
@m := 1
) AS b
) AS p4 ON p3.num = p4.num