有 两条selectSELECT 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]怎么样连接啊
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]怎么样连接啊
FROM ACTIVITIES AS A
LEFT JOIN MEMBER AS B ON A.CODE=B.CODE
WHERE A.TYPE=0 OR A.TYPE=120
GROUP BY A.CODE,B.[NAME]
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]
A.CODE,
B.[NAME],
SUM(Case A.TYPE When 0 Then A.POINTS Else 0 End) As TYPE0,
SUM(Case A.TYPE When 0 Then A.POINTS Else 0 End) As TYPE120
FROM ACTIVITIES AS A
LEFT JOIN MEMBER AS B ON A.CODE=B.CODE
WHERE A.TYPE=0
GROUP BY A.CODE,B.[NAME]
鱼犯糊涂了,呵呵
------有點,沒看明白啥意思
不是的我把code相同的记录连接后放在一行
---------
那應該是這個意思Select
A.CODE,
B.[NAME],
SUM(Case A.TYPE When 0 Then A.POINTS Else 0 End) As TYPE0,
SUM(Case A.TYPE When 0 Then A.POINTS Else 0 End) As TYPE120
FROM ACTIVITIES AS A
LEFT JOIN MEMBER AS B ON A.CODE=B.CODE
WHERE A.TYPE=0
GROUP BY A.CODE,B.[NAME]
A.CODE,
B.[NAME],
SUM(Case A.TYPE When 0 Then A.POINTS Else 0 End) As TYPE0,
SUM(Case A.TYPE When 120 Then A.POINTS Else 0 End) As TYPE120
FROM ACTIVITIES AS A
LEFT JOIN MEMBER AS B ON A.CODE=B.CODE
WHERE A.TYPE=0 OR A.TYPE=120
GROUP BY A.CODE,B.[NAME]
A.CODE,
B.[NAME],
SUM(Case A.TYPE When 0 Then A.POINTS Else 0 End) As TYPE0,
SUM(Case A.TYPE When 120 Then A.POINTS Else 0 End) As TYPE120
FROM ACTIVITIES AS A
LEFT JOIN MEMBER AS B ON A.CODE=B.CODE
GROUP BY A.CODE,B.[NAME]
a.type=0 and a.amount<>0
谢谢
A.CODE,
B.[NAME],
SUM(Case When A.TYPE = 0 And a.amount<>0 Then A.POINTS Else 0 End) As TYPE0,
SUM(Case When A.TYPE = 120 And a.amount<>0 Then A.POINTS Else 0 End) As TYPE120
FROM ACTIVITIES AS A
LEFT JOIN MEMBER AS B ON A.CODE=B.CODE
GROUP BY A.CODE,B.[NAME]
SUM' 附近有语法错误。
A.CODE,
B.[NAME],
SUM(Case A.TYPE When 0 Then A.POINTS Else 0 End) As TYPE0,
SUM(Case A.TYPE When 120 Then A.POINTS Else 0 End) As TYPE120
SUM(Case When A.TYPE = 0 And a.BILLAMOUNT<>0 Then A.POINTS Else 0 End) As TYPE1
FROM ACTIVITIES AS A
LEFT JOIN MEMBER AS B ON A.CODE=B.CODE
GROUP BY A.CODE,B.[NAME]
Select
A.CODE,
B.[NAME],
SUM(Case A.TYPE When 0 Then A.POINTS Else 0 End) As TYPE0,
SUM(Case A.TYPE When 120 Then A.POINTS Else 0 End) As TYPE120,
SUM(Case When A.TYPE = 0 And a.BILLAMOUNT<>0 Then A.POINTS Else 0 End) As TYPE1
FROM ACTIVITIES AS A
LEFT JOIN MEMBER AS B ON A.CODE=B.CODE
GROUP BY A.CODE,B.[NAME]
改為
SUM(Case A.TYPE When 120 Then A.POINTS Else 0 End) As TYPE120,