In a simple voting system as
CREATE TABLE elections ( election_id int(11) NOT NULL AUTO_INCREMENT, title varchar(255), CREATE TABLE votes ( election_id int(11), user_id int(11), FOREIGN KEYs
for getting the list of elections a user has voted, the following JOIN is used
SELECT * FROM elections JOIN votes USING(election_id) WHERE votes.user_id='x'
but how to get the list of elections a user has NOT voted?