>We are working on a teacher certification project and need to be able to track each students level through the program. We have written SQL statements that can determine what students have achieved each level. Is there a way I can check each subquery in sequence to determine the current level for each student. For example if the student is found in the level five query I know they are level five and I can end my search. Otherwise I need to check for their existence in each of the other level queries (Level 3, Level 2, and Level 2). I would like to have one SQL statement in the end that simply returns the students id and current level. Is this possible?
>
>Thanks In Advance
>
>Jeff Hibbs
>The Blencowe Group

Jeff,

It may be better if you post some code here - your question doesn't have enough information to work with.

Otherwise I may suggest to create table valued function that would check each level (assuming it's a separate table) in IF/ELSE and return the information about the student.