Select query

[Ad Bec]

I would like to perform select on the following two tables,

tblPoll
PollID

tblPollResults
PollID
AnswerID
UserID


I want to select all the distinct PollID's that the UserID didn't answer.

What would be the most efficient SQL for this?

thanks!

[zoeski80]

See attached code

HTH

get all the PollIDs not associated with #UserID#

SELECT PollID
FROM tblPoll
WHERE NOT PollID IN (
SELECT PollID
FROM tblPollResults
WHERE UserID = #UserID#
)

get all the PollIDs not associated with any UserID

SELECT PollID
FROM tblPoll
WHERE NOT PollID IN (
SELECT PollID
FROM tblPollResults
)

tblPoll shoulnd't have any duplicate entries so the results will be DISTINCT.

[mxstu]

What is the most efficient can be affected by a number of factors (db type, indexes, etc).
1) Post the queris you have tried so far
2) What determines "he UserID didn't answer"?