作者fake01 (code)
看板Database
标题Re: [SQL ] 两个表格连结 join
时间Sun Oct 7 17:10:40 2012
join 还是碰到问题,又来询问了
relation
Carname TotalKm
a 100
a 75
b 10
b 20
behavior
Carname month Cozy
a 5 1
a 5 3
b 5 2
b 5 4
结果想要
Carname TotalKm month Cozy
a 175 5 4
b 30 5 6
我下的是这样
SELECT
convert(varchar(255),behavior.Carname)'Carname',
SUM(TotalKm)'TotalKm',
convert(varchar(255),behavior.Month)'month',
SUM(Cozy)'Cozy'
FROM
[iiicar].[dbo].[behavior]
inner Join
[iiicar].[dbo].[relation]
on
convert(varchar(255),behavior.Carname)
= convert(varchar(255),relation.Carname)
group by
convert(varchar(255),behavior.Carname),
convert(varchar(255),behavior.Month)
但是好像会多加一次变成
Carname TotalKm month Cozy
a 250 5 8
b 60 5 12
请问怎麽解决呢?
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 61.222.59.181
1F：→ ji394su33000:两个table要分开做sum，再用carname 串起来 10/07 20:05
2F：→ fake01:请问怎麽做?有点模糊 10/07 20:06
3F：→ fake01:(SELECT convert(varchar(255),Carname)'Carname',SUM(Runt 10/07 22:28
4F：→ fake01:time)'Runtime' From relation group by convert(varchar 10/07 22:29
5F：→ fake01:(255),Carname))(SELECT convert(varchar(255),Carname)'Ca 10/07 22:30
6F：→ fake01:zy'From behavior groupby convert(varchar(255),Carname)) 10/07 22:30
7F：→ fake01:是可以分开SUM 但怎麽串起来呢? 10/07 22:31
8F：→ fake01:以解决 10/07 22:44