Jika sudah melibatkan banyak query, buatkan pengenal yang jelas untuk
setiap field yang di pilih:
select pr_employee.employee_id, count (pr_employee.employee_id) as hitung
from pr_employee
inner join (
select emp_master.employee_id,count(emp_master.employee_id)as hitung
from emp_master
inner join emp_master_new on emp_master.employee_id =
emp_master_new.employee_id
group by emp_master.employee_id
) as table_bantu1
on pr_employee.payroll_id = table_bantu1.employee_id
group by pr_employee.employee_id;
employee_id di select pertama ambigious, milik tabel mana ...., sehingga
harus diberikan alias yang benar.
aksan kurdin
yokananwahyono wrote:
Dear Pakar acces
Saya mencoba membuat quey dengan menggunakan tiga table sekaligus
PR_EMPLOYEE JOIN DENGAN (EMP_MASTER JOIN EMP_MASTER_NEW)
Tapi kok ada error y
Berikut syntacnya
Kira2 salahnya d mana
Selama ini saya memakai quey bantuan
select employee_id, count (employee_id) as hitung
from pr_employee
inner join
(select emp_master.employee_id,count(emp_master.employee_id)as hitung
from emp_master inner join emp_master_new
on emp_master.employee_id = emp_master_new.employee_id
group by emp_master.employee_id) as table_bantu1
on pr_employee.payroll_id = table_bantu1.employee_id
group by pr_employee.employee_id;
thx
yokanan_wahyono
