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
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)