如果a,b,c是固定并且已知内容的话:SELECT id2, SUM(CASE id1 WHEN 'a' THEN money ELSE NULL END) AS a, SUM(CASE id1 WHEN 'b' THEN money ELSE NULL END) AS b, SUM(CASE id1 WHEN 'c' THEN modey ELSE NULL END) AS c FROM 表c GROUP BY id2如果id1可变的话,用我的文档里提供的代码生成存储过程,然后调用: CorssTab '表2', 'id1', 'id2', 'money', sum
SUM(CASE id1 WHEN 'a' THEN money ELSE NULL END) AS a,
SUM(CASE id1 WHEN 'b' THEN money ELSE NULL END) AS b,
SUM(CASE id1 WHEN 'c' THEN modey ELSE NULL END) AS c
FROM 表c GROUP BY id2如果id1可变的话,用我的文档里提供的代码生成存储过程,然后调用:
CorssTab '表2', 'id1', 'id2', 'money', sum