Oke thx berat pak Ternyata bisa
_____ From: [email protected] [mailto:[email protected]] On Behalf Of Aksan Kurdin Sent: Monday, January 18, 2010 5:23 PM To: [email protected] Subject: Re: [belajar-access] Select in select 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
