Dear all,
Saya punya query seperti ini,
SELECT d.department_id, d.department_name, count(e1.employee_id) employees,
NVL(TO_CHAR(AVG(e1.salary), '99999.99'), 'No average') avg_sal,
e2.last_name, e2.salary, e2.job_id
FROM department d, employees e1, employees e2
WHERE d.department_id = e1.department_id(+)
AND d.department_id = e2.department_id(+)
GROUP BY d.department_id, d.department_name, e2.last_name, e2.job_id
Nah yang aku ngga ngerti kenapa harus ada 2 employees, kenapa ngga langsung aja
?
Mohon penjelasannya ya, thanx before.
Hendra
---------------------------------
Everyone is raving about the all-new Yahoo! Mail beta.
[Non-text portions of this message have been removed]
