作为两个子查询再查一次就行了
select isnull(t1.[详情],t2.[详情]) AS [详情],
ISNULL(t1.[次数], 0) AS [赠_次数],
ISNULL(t2.[次数], 0) AS [送_次数],
ISNULL(t1.[次数], 0) + ISNULL(t2.[次数], 0) AS [总次数]
FROM
(....) AS t1
FULL OUTER JOIN
(....) AS t2
ON t1.[详情]=t2.[详情]
内容全部来源于网络收集，如有侵权，请联系网站删除！
QQ：24596024