Supporting many-to-one relationship

[majidazimi]

This may not be an issue but I'm having difficulty modeling many-to-one relation ship in order to simulate left join. Assume:

Manager population containing ID, MANAGER_NAME
Employee population containing ID, EMPLOYEE_NAME. Now I need to build a relation where each employee can have random number of managers (0, 1, 2, 3, ....) and produce a result set as EMPLOYEE_NAME, MANAGER_NAME (Where MANAGER_NAME can be null sometimes).