Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Projects(projectID, CreatedByID)
- Employees(empID,depID)
- Departments(depID,OfficeID)
- Offices(officeID)
- SELECT *
- FROM Projects P
- JOIN Employees E ON P.CreatedBY = E.EmpID
- JOIN Departments D on E.DepID = D.DepID
- JOIN Offices O on D.officeID = O.officeID
- WHERE O.officeID = @SomeOfficeID
Add Comment
Please, Sign In to add comment
