Hi,
I am trying to retrieve all the qualification details of all the employees in the below format
for example:
employeeno employeename qualification1 university1 qualification2 university2 qualification3 university3
123 Lucy Intermediate xxxx Degree xxxxx Masters XXXX
324 David Intermediate YYYY Degree XXXX null null
Below is the query I wrote
select papf.employee_number, papf.full_name,pap.name "position" ,pqv.name "Qualification", pqv.title"specialization",pqv.awarded_date
from per_all_people_f papf,
per_all_assignments_f paaf,
per_all_positions pap,
per_qualifications_v pqv
where papf.person_id = paaf.person_id
and paaf.position_id = pap.position_id
and pqv.person_id = papf.person_id
and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date
and trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date;
But it gives me the below output
Employee_number employee name position qualification specialization
11 Rafat Imam Abdon AlHarbi HR Director Masters Degree Business Administration
11 Rafat Imam Abdon AlHarbi HR Director Professional Diploma CIPD
There are 2 separate rows for each qualification but I need in a single row for each employee.
Please help me how to get the data