如何计算和显示0 [英] How to count and display 0

问题描述

这是我的SQL语句

Here is my SQL Statement

select CANDIDATE.Candidate_Party, COUNT(CANDIDATE.Candidate_Number) AS VotesNumber
from CANDIDATE 
left outer join VOTE on CANDIDATE.Candidate_Number = CANDIDATE.Candidate_Number
WHERE CANDIDATE.Candidate_Number = VOTE.Candidate_Number AND CANDIDATE.Candidate_Portfolio = 'Missionvale Representative'
 GROUP BY CANDIDATE.Candidate_Party

i也尝试了内连接，但它没有返回0

i also tryed inner join but it does not return 0

推荐答案

hi
try this query


select CANDIDATE.Candidate_Party, COUNT(CANDIDATE.Candidate_Number) AS VotesNumber
from CANDIDATE
left outer join VOTE on CANDIDATE.Candidate_Number = VOTE.Candidate_Number
WHERE
CANDIDATE.Candidate_Portfolio = 'Missionvale Representative'

 GROUP BY CANDIDATE.Candidate_Party

这篇关于如何计算和显示0的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！