Re: [SQL ] 兩個表格連結 join

看板Database作者 (code)時間13年前 (2012/10/07 17:10), 編輯推噓0(0推 0噓 8→)
留言8則, 2人參與, 最新討論串3/3 (看更多)
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
→
10/07 20:05, , 1F
兩個table要分開做sum，再用carname 串起來
10/07 20:05, 1F
→
10/07 20:06, , 2F
請問怎麼做?有點模糊
10/07 20:06, 2F
→
10/07 22:28, , 3F
(SELECT convert(varchar(255),Carname)'Carname',SUM(Runt
10/07 22:28, 3F
→
10/07 22:29, , 4F
time)'Runtime' From relation group by convert(varchar
10/07 22:29, 4F
→
10/07 22:30, , 5F
(255),Carname))(SELECT convert(varchar(255),Carname)'Ca
10/07 22:30, 5F
→
10/07 22:30, , 6F
zy'From behavior groupby convert(varchar(255),Carname))
10/07 22:30, 6F
→
10/07 22:31, , 7F
是可以分開SUM 但怎麼串起來呢?
10/07 22:31, 7F
→
10/07 22:44, , 8F
以解決
10/07 22:44, 8F
‣ 更多 fake01 的文章
文章代碼(AID): #1GSKSKSH (Database)
‣ 更多 fake01 的文章
文章代碼(AID): #1GSKSKSH (Database)