SQL: Find missing questions (in a group) in the answers table
Posted on 2011-09-20
I have a questions table with questions that are grouped together.
20 questions belong to group 1
25 questions belong to group 2
18 questions belong to group 3
QuestionID(unique), QuestionGroup, Question
I need to find the questions in each group that are missing in the answers table
QuestionID, UserID, QuestionAnswer
The question I need to answer is: Which questions did the user NOT answer in each question group. This is indicated by the missing rows in the answers table.
Thanks in advance for any help you can give