Hello SQL experts and gurus, I am currently working on an employee database
in DB2 and I need to create a VIEW to augment my table with one column.
Basically this is a simple employee database and the new column should
contain the word 'MANAGER' for employees who manage someone and 'EMPLOYEES'
for employees who manage no one.
is creating a view like this even possible? if so does anyone have any ideas
on how to create it? thanks.