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