MYSQL SELECT FROM MULTIPLE COLUMS FROM TABLES

MYSQL SELECT FROM MULTIPLE COLUMS FROM TABLES

I am trying to retrieve information from a mysql database. I have the
following tables:
Qualifications(qualificationid, qualificationname, personid,status)
Address(addressid, addressline1,city,province,areacode,personid)
score(scoreid, score.choices,personid,jobid)
I use typed the following mysql statement to retrieve the data
SELECT score.personid, qualifications.qualificationname, score.score
FROM
Qualifications, Score, Address
WHERE
score.jobid=58
AND
qualifications.qualificationName ='Human Resource Management'
AND
aadress.province ='Western Cape'
ORDER BY score.score
LIMIT 0,20;
this seems to work for everything else but doesn't restrict the province
to western cape.
Please assist, where am I going wrong ?