Select TestID,Name from Test where Status='P' and StartDate<='#Today#' and EndDate>'#Today#' and TestID Not in (Select TestID from TriviaQuiz where UserID=#UserID#) Select TestID,Name from Test where TestID in (Select TestID from TriviaQuiz where UserID=#UserID#)
Cruisemates Trivia Game