I need help... have to admit it!!
The question (Assign2 Q2) :
The human Resources department needs to find the names and hire dates for all employees who were hired before 29 January 2000, along with their managers’ names. Sample results are shown in the table below.
The answer is suposed to be a sub query (not a join)........ I just cannot get a sub query that will give me the managers name at the same time I get the employee's name.