Cruisemates Cruise Trivia Game

Select TestID, StartDate, Name from Test where TypeCode='D' and Status='P' and StartDate<='#Today#' and EndDate>'#Today#' and TestID Not in (Select TestID from TriviaQuiz where UserID=#UserID#) order by 'StartDate' Select TriviaQuiz.TestID,Test.Name from TriviaQuiz left join test on TriviaQuiz.TestID=Test.TestID where TriviaQuiz.UserID=#UserID# and TriviaQuiz.Date>='#DateFormat(FirstDate,"mm/dd/yyyy")#' order by Date desc

CruiseMates Daily Cruise Trivia Game
Think you're an expert?
Enter our cruise trivia contest and let's see what you're really made of!
A New Game Every Day!

Copyright © 2000 - , Cruisemates. All rights reserved.