34,576
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE tb (zh varchar(20),tqx varchar(20),y1 varchar(20))
INSERT into tb
SELECT '59758','ef','6' UNION ALL
SELECT '59758','eq','3' UNION ALL
SELECT '59758','wf','5'
IF object_id('tb2') IS NOT NULL
DROP TABLE tb2
CREATE TABLE tb2 (zh varchar(20),tqx varchar(20),y2 varchar(20))
INSERT INTO tb2
SELECT '59758','ef','3' UNION ALL
SELECT '59748','g1','5' UNION ALL
SELECT '59758','wq','7'
SELECT isnull(a.zh,b.zh),isnull(a.tqx,b.tqx),a.y1,b.y2 FROM tb a FULL JOIN tb2 b on a.zh=b.zh
and a.tqx=b.tqx
/*CREATE TABLE t1(站号 VARCHAR(10) ,TQX varchar(10) ,Y1 int )
INSERT INTO t1
SELECT '59758','ef', 6
UNION ALL
SELECT '59758', 'eq', 3
UNION ALL
SELECT '59758', 'wf', 4
CREATE TABLE t2(站号 VARCHAR(10) ,TQX varchar(10) ,Y2 int )
INSERT INTO t2
SELECT '59758', 'ef', 3
UNION ALL
SELECT '59758', 'g1' , 5
UNION ALL
SELECT '59758', 'wq', 7
*/
SELECT 站号,TQX,SUM(y1) y1, SUM(y2)y2
FROM (
SELECT 站号,TQX,y1,NULL y2
FROM t1
UNION
SELECT 站号,TQX,NULL y1, y2
FROM t2 )a
GROUP BY 站号,TQX
/*
站号 TQX y1 y2
---------- ---------- ----------- -----------
59758 ef 6 3
59758 eq 3 NULL
59758 g1 NULL 5
59758 wf 4 NULL
59758 wq NULL 7
警告: 聚合或其他 SET 操作消除了 Null 值。
*/
select tq1.站好 ,tq1.TQX,tq1.Y1,tq2.Y2
from 表1 as tq1,表2 as tq2
where tq1.站好 = tq2.站好
试一试 大概是这样子 我现在没有环境