LoslegenKostenlos loslegen

Picking an outer join type

Imagine that eSymphony will grow their employee base and they decide to create departments based on the activities. You want to find out what department each employee works in. Additionally, employees that are not related to a department need to show up. Similarly, departments with no employees need to show up. The final table should look like this:

What type of join should you use to combine information from the Employee and Department tables?

Diese Übung ist Teil des Kurses

Introduction to Oracle SQL

Kurs anzeigen

Interaktive Übung

Setze die Theorie in einer unserer interaktiven Übungen in die Praxis um

Übung starten