Write SQL code to join two tables, and explain what OOP is, including inheritance and polymorphism.
Use the provided employees and departments tables. Return every employee, including employees without a matching department, and briefly explain the object-oriented programming concepts requested.
employee_id, employee_name, department_name, and divisionemployee_id ascending| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee full name |
| department_id | INT | Referenced department identifier |
| job_title | VARCHAR(100) | Employee job title |
| Column | Type | Description |
|---|---|---|
| department_idPK | INT | Unique department identifier |
| department_name | VARCHAR(100) | Department name |
| division | VARCHAR(100) | Organizational division |