Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT PROJ_NAME, ROUND(PROJ_VALUE, 2) AS 'PROJ VALUE', ROUND(PROJ_BALANCE, 2) AS 'PROJ BALANCE',
- EMPLOYEE.EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMPLOYEE.JOB_CODE, JOB.JOB_DESCRIPTION, JOB.JOB_CHG_HOUR
- FROM PROJECT, EMPLOYEE, JOB
- WHERE EMPLOYEE.EMP_NUM = PROJECT.EMP_NUM
- AND JOB.JOB_CODE = EMPLOYEE.JOB_CODE
Add Comment
Please, Sign In to add comment