project number | manager last name | manager fast name | employee id | employee last name | employee first name |
---|---|---|---|---|---|
1001 | Smith | Tom | 101 | Smith | Tom |
1001 | Smith | Tom | 103 | Jones | Mary |
1005 | Smith | Tom | 103 | Jones | Mary |
1001 | Smith | Tom | 105 | Burns | Jane |
1001 | Smith | Tom | 115 | Chin | Amanda |
1019 | Burns | Michael | 110 | Burns | Michael |
1019 | Burns | Michael | 115 | Chin | Amanda |
1025 | Burns | Michael | 110 | Burns | Michael |
1030 | Burns | Michael | 110 | Burns | Michael |