Re: [SQL ] 投票結果統計

[danielguo (Daniel Guo)]

SELECT t.`idno` AS `TOPICID`,
    SUM(IF(p.`vote` = 'A', 1, 0)) AS `A_votes`,
    SUM(IF(p.`vote` = 'B', 1, 0)) AS `B_votes`
FROM `topic` t
LEFT JOIN `poll` p
    ON t.`idno` = p.`topicid`
GROUP BY t.`idno`

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 71.84.58.153
推 magicfx:感謝 卡很久了~