Well without knowing the table set up here is a shot in the dark
You would have the employees tabel and the employees table would have a
type field. This type field would typically be supervisior,
employee,manager etc
You could then use that type to populate the view or you could leave it as
is with the type field and just query from that
Hope this helps
Darren
On Tue, 12 Feb 2002, database beginner wrote:
> 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.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>