The following tables exist
QuizID (primary key)
I need to develop a stored procedure that will return all of the quizes from the QuizTable that are available and that a particular user has not yet taken.
To return a list of quizes with no entries at all in the UserQuiz table, I'm using the following SQL:
select Quiz.QuizID, Quiz.Title, Quiz.Description,
Quiz.IsAvailable FROM Quiz Left Outer Join
UserQuiz ON Quiz.QuizID = UserQuiz.QuizID
Where UserQuiz.QuizID is null
This is only getting me 1/2 the way to where I need to end up.
Any suggestions greatly appreciated.