联查两表，同属性值相加

联查两个表sql

from（）里面写第一个表的查询语句，full join放第二个表的查询语句

SELECT
	isnull( a.Score,0)+isnull(b.Score,0) Score,
	isnull( a.Uscore,0) +isnull(b.Uscore,0) Uscore,
	isnull( a.TMND, b.TMND ) TMND 
FROM
	(
SELECT
	sum( Score ) AS Score,
	sum( Uscore ) AS Uscore,
	TMND 
FROM
	( SELECT DISTINCT ID, Uscore, TMND, Score FROM ZhgPaper WHERE Ksid = '20190002' AND Stuid = '1815925346' ) AS bb
GROUP BY
	TMND 


) a
FULL JOIN (
	SELECT
		sum( Score ) AS Score,
		sum( Uscore ) AS Uscore,
		TMND 
	FROM
		( SELECT DISTINCT ID, Uscore, TMND, Score FROM XztPaper WHERE Ksid = '20190002' AND Stuid = '1815925346' ) AS ss 
	GROUP BY
		TMND 


) b 
 	on  a.TMND = b.TMND

这个语句是吧Score和Uscore两个列对应在同TMND列的每行的值相加

例如：

a表

a    b    c

1    2    N

1   1     M

1    1     Z

b表

a    b    c

1    1    N

2     1    M

查询结果为：

a    b    c

2     3     N

3      3    M

1     1     Z