Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT PROJECTS.PROJECT_ID,PROJECTS.MANAGER_ID FROM PROJECTS
- JOIN ALLOCATIONS ON PROJECTS.PROJECT_ID = ALLOCATIONS.PROJECT_ID
- WHERE PROJECTS.MANAGER_ID = ALLOCATIONS.EMPLOYEE_ID
- GROUP BY PROJECTS.MANAGER_ID,PROJECTS.PROJECT_ID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement