Employee management exercise 9

Back to Employee management

Select all the data of employees, including each employee's department's data.

| SELECT ssn, name, lastname, department FROM employees
| SELECT code, name, budget FROM departments
| RENAME code department
| RENAME name departmentname
| JOIN department
12 rows 0 msec
ssn name lastname department budget departmentname
123234877 Michael Rogers 14 65000 IT
152934485 Anand Manikutty 14 65000 IT
222364883 Carol Smith 37 15000 Accounting
326587417 Joe Stevens 37 15000 Accounting
332154719 Mary-Anne Foster 14 65000 IT
332569843 George ODonnell 77 55000 Research
546523478 John Doe 59 240000 Human Resources
631231482 David Smith 77 55000 Research
654873219 Zacary Efron 59 240000 Human Resources
745685214 Eric Goldsmith 59 240000 Human Resources
845657245 Elizabeth Doe 14 65000 IT
845657246 Kumar Swamy 14 65000 IT