N1 N2 N3 N1 N2 N4
---------------- ----------------
A 123 234 A 456 231
A 456 343 A 789 34
合并成N1 N2 N3 N4
----------------------------
A 123 234
A 456 343 231
A 789 34
如何实现 请教
select T1.N1,T1.N2,T1.N3,T2.N4
FROM T1,T2
WHERE T1.N2=T2.N2
ORDER BY 2
FROM T1,T2
WHERE T1.N2=T2.N2
ORDER BY 2
温馨提示:答案为网友推荐,仅供参考