Help in a SQL query

[Selo]

Hello everyone,

I've got these two tables;

users(pic,username,id) and votes(voter_id, voted_id, id, rating)

What I'm trying to do is getting all users from table 1 that weren't voted before by the user who's browsing the script.

The closest I've got is this

SELECT pic,username,id FROM users WHERE id IN (SELECT voted_id FROM votes WHERE voter_id <> '$userid')"

But this isn't enough, as there might be some users that were voted by people different from $userid AND by $userid himself.... so I'm quite stuck.

Thanks for your help!

[pete_bisby]

[SQL]
SELECT pic, username, id
FROM users A LEFT JOIN voters B ON A.id = B.voter_id
WHERE B.voter_id IS NULL;
[/SQL]

This is assuming that the id from table users is the same as the voter_id from table `voters'.