Sql Quizes?
Nov 23, 2006anyone know where i can find more complex sql tests online to test more then just simple select statements but other stuff such as joins etc..?
View 11 Replies
ADVERTISEMENT
Help With Sql Query Selecting Quizes That Have Not Been Taken
May 23, 2007Hello,The following tables existQuizTableQuizID (primary key)TitleDescriptionIsAvailableUserQuizTableUserQuizID (PK)QuizID (FK)DateTimeCompleteScoreUserNameI 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 JoinUserQuiz ON Quiz.QuizID = UserQuiz.QuizIDWhere UserQuiz.QuizID is nullAND Quiz.IsAvailable=0This is only getting me 1/2 the way to where I need to end up. Any suggestions greatly appreciated.
View 3 Replies View Related