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...