CODEWITHSUNDEEP
mysql
CyberFla
CyberFla

Reputation: 71

MySql relational query results

I have created this database. enter image description here

I am new to relational database. I am trying to run a query to display 

Select candidates.CandidateName, candidates.CandidateVotes, candidates.Party, race.RaceName, mainrace.MainRaceName
From candidates  
JOIN ....
...

I've tried different options but I keep getting fields from candidates but nothing from other tables. 

SELECT `candidates`.`CandidateName`, `mainrace`.`MainRaceName`, `race`.`RaceName`
FROM `race`
LEFT JOIN `electionpc`.`candidates`
ON `race`.`RaceID` = `candidates`.`RaceID`

Once I run this query I get #1054 - Unknown column 'mainrace.MainRaceName' in 'field list'

Upvotes: 0

Views: 33

Answers (1)

jeffjenx
jeffjenx

Reputation: 17487

You need to join both tables:

SELECT candidates.CandidateName, mainrace.MainRaceName, race.RaceName
FROM candiates
JOIN race ON race.RaceID = candidates.RaceID
JOIN mainrace ON mainrace.MainID = candidates.MainID

Upvotes: 3

Related Questions