Assuming sequenceid is required, the following result was found.
returns all the joined tables and displays the decode name. Let's pretend the info we want is rather simple: SELECT [sequenceID], [student_reference], [student_title_code], [student_name], [student_gender_code], [student_country_birth_code],...