I have the following Query and I have been struggling to solve it. it's not really a homework assignment I just want to know how to do this in order to solve similar question on my homework. The difficult part for me is after i find matching project ids how do i connect them with the employee pairs.
I'd appreciate any help.
This is the question:
I need to show the names of the employees who work in the same project.
The result set should be pairs of employee names and project name,such as:
'name1 name2 project1' , 'name1 name3 project1' etc.
The result set should list only unique and real pair records.
For example,it shouldn't include either 'name2 name1 project1'
or 'name1 name1 project1' records.
Using This DB Scheme: