• I selected option 2 (and only option 2) and was told I was wrong, as I needed to select option 2 & 3. However option 3 returns the results in the following order:

    EmpName DateOfLeaving

    dcd2000-08-10 00:00:00.000

    abc1999-10-10 00:00:00.000

    bcd1998-11-11 00:00:00.000

    ccdNULL

    eedNULL

    and the question stated that the solution should be:

    EmpName DateOfLeaving

    Bcd 11 Nov 1998

    Abc 10 Oct 1999

    Dcd 10 Aug 2000

    Ccd null

    Eed null

    Therefore I guess thtat the question is worng. At least I should get a point for writing this reply! 😛

    Regards,

    Phil