Kapitel 5-1
Füllen Sie die (durch <Zahl>
gekennzeichneten) Lücken der folgenden Abfrage aus, um die gezeigten Resultate zu erhalten:
mysql>SELECT e.emp_id, e.fname, e.lname, b.name
->FROM employee e INNER JOIN <1> b
->ON e.assigned_branch_id = b.<2>;
+--------+----------+-----------+---------------+ | emp_id | fname | lname | name | +--------+----------+-----------+---------------+ | 1 | Michael | Smith | Headquarters | | 2 | Susan | Barker | Headquarters | | 3 | Robert | Tyler | Headquarters | | 4 | Susan | Hawthorne | Headquarters |
| 5 | John | Gooding | Headquarters | | 6 | Helen | Fleming | Headquarters | | 7 | Chris | Tucker | Headquarters | | 8 | Sarah | Parker | Headquarters | | 9 | Jane | Grossman | Headquarters | | 10 | Paula ...
Get Einführung in SQL now with the O’Reilly learning platform.
O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.