Bpk bisa disampaikan pesan errornya? Barangkali data type nya berbeda.
 Thank's. 




________________________________
From: yokananwahyono <[email protected]>
To: [email protected]
Sent: Mon, January 18, 2010 4:00:14 PM
Subject: [belajar-access] Select in select

  
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
__.._,_.___
Reply to sender | Reply to group Messages in this topic (1) 
Recent Activity:        * New Members 15 
Visit Your Group Start a New Topic 
SPAM IS PROHIBITED 
MARKETPLACE
Going Green: Your Yahoo! Groups resource for green living
 
Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use
. 




      

Kirim email ke