SELECT 连接的 问题
有 两条select
SELECT A.CODE,B.[NAME],SUM(A.POINTS)
FROM ACTIVITIES AS A
LEFT JOIN MEMBER AS B ON A.CODE=B.CODE
WHERE A.TYPE=0
GROUP BY A.CODE,B.[NAME]
SELECT A.CODE,B.[NAME],SUM(A.POINTS)
FROM ACTIVITIES AS A
LEFT JOIN MEMBER AS B ON A.CODE=B.CODE
WHERE A.TYPE=120
GROUP BY A.CODE,B.[NAME]
怎么样连接啊
[解决办法]
這個意思？？
SELECT A.CODE,B.[NAME],SUM(A.POINTS)
FROM ACTIVITIES AS A
LEFT JOIN MEMBER AS B ON A.CODE=B.CODE
WHERE A.TYPE=0
GROUP BY A.CODE,B.[NAME]
Union All
SELECT A.CODE,B.[NAME],SUM(A.POINTS)
FROM ACTIVITIES AS A
LEFT JOIN MEMBER AS B ON A.CODE=B.CODE
WHERE A.TYPE=120
GROUP BY A.CODE,B.[NAME]
