selecting data from 2 tables

[eluser]Bigil Michael[/eluser]
now it shows an error like this

A Database Error Occurred

Error Number: 1140

Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

SELECT `candidate_name`, MAX(`candidate_votes`) AS candidate_votes FROM (`candidate_details`) WHERE `constituency_id` = '1' AND `elect_year` = '2010'

can any one solve my problem
thanks in advance..