Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* *** SQL-Query-CH03-53 *** */
- SELECT
- FROM
- ProjectName, FirstName, LastName, HoursWorked EMPLOYEE AS E JOIN ASSIGNMENT AS A
- ON E.EmployeeNumber = A.EmployeeNumber JOIN PROJECT AS P ON A.ProjectID = P.ProjectID
- ORDER BY P.ProjectID, A.EmployeeNumber;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement