我正在进行SQL查询以建立报表布局。我已经总结了所有需要的数据,但我想不出一种方法来使用SQL将部分a和部分B并排。两个部分都来自同一个表,可以使用相同的键连接。tot_count是个体计数(ind_count)的聚合度量。这可能使用mysql查询吗?
-------- section A -------- -------- section B --------
tot_count empid ind_count tot_count empid ind_count
3323 XX 2466 101 DD 40
AA 835 CC 36
YY 22 EE 11
LL 7
OTHERS 7
首先,您可以将行号引入A和B部分。例如
SELECT @ROW := @ROW + 1 AS row, first_name
FROM users, (SELECT @ROW := 0) r;
然后
SELECT
A.tot_count as tot_countA,
A.emptid as emptidA,
A.ind_count as ind_countA,
B.tot_count as tot_countB,
B.emptid as emptidB,
B.ind_count as ind_countB,
FROM
(subquery A with row column) A inner join
(subquery B with row column) B on A.row=b.row