selecting data from 2 tables

[eluser]Bigil Michael[/eluser]
can u help me
this is the code i used print the result according to any purticular year

SELECT con.constituency_name, con.elect_year, con.constituency_id, con.total_voters, con.total_polled ,can.candidate_name, can.candidate_votes FROM constituency_details AS con, candidate_details AS can WHERE can.constituency_id = con.constituency_id AND can.elect_year = 2011 AND con.elect_year = 2011 AND candidate_votes = (SELECT MAX(candidate_votes)FROM candidate_details)

but it print the result only once

can u help he??

i think a small change required in my query.....

if possible please help me......
thanks in advance.