Advertisement
idotherest34

query language

Apr 4th, 2021
624
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.25 KB | None | 0 0
  1. /* *** SQL-Query-CH03-53 *** */
  2. SELECT
  3. FROM
  4. ProjectName, FirstName, LastName, HoursWorked EMPLOYEE AS E JOIN ASSIGNMENT AS A
  5. ON E.EmployeeNumber = A.EmployeeNumber JOIN PROJECT AS P ON A.ProjectID = P.ProjectID
  6. ORDER BY P.ProjectID, A.EmployeeNumber;
  7.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement