Sebastian
> I think you could use a query in your select clause to do this:
>
> SELECT MAX(QuizDate) as QuizDate, QuizID,
> QuizPercent = (SELECT QuizPercent FROM Test_Board_Biomed as t1
> WHERE t1.Customer_ID = 21
> and t1.QuizID = Test_Board_Biomed.QuizID
> and t1.QueryDate = MAX(Test_Board_Biomed.QuizDate))
> FROM Test_Board_Biomed
> WHERE Customer_ID = 21
> GROUP BY QuizID
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
