Recent content by mmsmns

hi i have 3 tables 1- occupation (occupation_id pk) 2- employee(cpr_number pk, occupation_id fk) 3- school(school_id pk, cpr_number fk) i want to display all occupation from occupation table for each school if the occupation was filled with an employee display cpr number otherwise...