[SOLVED] Need help creating a SQL querry

[TheJoey]

Hey Guys,

Just wondering if i had a database that stored information of users that partipate in a poll. The question i have is what is the basics for writing a SQL querry to find out

the registered users who have not voted in the poll.

Just wondering if this can be done.

[artacus]

SELECT *
FROM users
WHERE user_id NOT IN (
  SELECT user_id
  FROM votes
  WHERE poll_id = 1
)

[TheJoey]

Thank you so much works a treat.