Just Ask..
query yang dibikin untuk mencari model seperti :
depart_id depart_name emp avg_sal last_name salary job
========= =========== === ======= ========= ====== ===
1 Purchase 2 12 brat 10 x
Purchase 2 12 frank 14 y
2 Sales 3 15 sugeng 10 p
Sales 3 15 bento 20 u
Sales 3 15 kusmus 15 y
perkiraan saya mungkin jika hanya satu employee table
yang dimasukan ke query maka, last_name,salary,job
tidak keluar karena employee yang pertama digunakan
untuk group function (AVG).. maka ditambatkan field2
yang diperlukan dengan employee2..
jika ada cara lain tell me ok
thank u
--- bapux oke <[EMAIL PROTECTED]> wrote:
> 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]
>
>
____________________________________________________________________________________
Be a PS3 game guru.
Get your game face on with the latest PS3 news and previews at Yahoo! Games.
http://videogames.yahoo.com/platform?platform=120121
