34,838
社区成员




SELECT ISNULL(a1.userid,a2.userid) userid,
ISNULL(a1.val,0.0)*0.5+ISNULL(a2.val,0.0)*0.4 val
FROM (SELECT userid, SUM(val*1.0) val FROM t1 GROUP BY userid) a1
FULL JOIN (SELECT userid, SUM(val*1.0) val FROM t2 GROUP BY userid) a2
ON a1.userid = a2.userid
SELECT ISNULL(a1.val,0.0)*0.5+ISNULL(a2.val,0.0)*0.4 val,
ISNULL(a1.userid, a2.userid) userid
FROM
(SELECT userid, SUM(val*1.0) val FROM t1 GROUP BY userid) a1
FULL JOIN
(SELECT userid, SUM(val*1.0) val FROM t2 GROUP BY userid) a2
ON a1.userid = a2.userid
order by 1 desc