Hi I have requirement as follows
EmpID Emp Last Name Emp First Name Emp Location CCS Location Name Supervision Type Officer Name
13 john smith Hallifax chicago suptype1 test1
13 john smith Hallifax chicago suptype2 test2
in the above output one employee (13) has 2 officers with 2 types of supervision role.
i want the output as a single row for employee 13 with supervisor 1 and supervisor2 . can you please advise.
i am getting the output from emp,supervisor,location tables(3 tables)
ID Last Name First Name Location sup Location Supervision Type1 Supervision Type2 Officer name1 officer name2
13 john smith Hallifax chicago suptype1 suptype2 test1 test2