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
