Guest User

Untitled

a guest
Jan 20th, 2019
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. SELECT PROJ_NAME, ROUND(PROJ_VALUE, 2) AS 'PROJ VALUE', ROUND(PROJ_BALANCE, 2) AS 'PROJ BALANCE',
  2. EMPLOYEE.EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMPLOYEE.JOB_CODE, JOB.JOB_DESCRIPTION, JOB.JOB_CHG_HOUR
  3. FROM PROJECT, EMPLOYEE, JOB
  4. WHERE EMPLOYEE.EMP_NUM = PROJECT.EMP_NUM
  5. AND JOB.JOB_CODE = EMPLOYEE.JOB_CODE
Add Comment
Please, Sign In to add comment