saya coba pake query ini pd datawindow, tapi error, yaitu pd
"left outer join (select ..."
spt nya dw tidak bisa menggunakan sub select.. atau apa ada yg
terlewat oleh saya
pls.. saya butuh query ini berhasil
thank
yazid
========================
diasumsikan ada 2 table: 'dept' dan 'emp' yang direlasikan atas kolom
'namadept' di masing2 table
maka jadinya seperti ini;
select
dept.namadept,
lastmonth.totalbulanlalu,
thismonth.totalbulanini
from dept left outer join
(select dept.namadept, count(emp_id) as totalbulanlalu from dept
inner join emp on dept.namadept= emp.namadept
where emp.emp_joindate < thismonth-1 and emp.emp_resigndate >=
thismonth-1 group by dept.namadept) as lastmonth
on dept.namadept = lastmonth.namadept
left outer join
(select dept.namadept, count(emp_id) as totalbulanini from dept inner
join emp on dept.namadept = emp.namadept
where emp.emp_joindate < thismonth and emp.emp_resigndate > thismonth
group by dept.namadept)
as thismonth on dept.namadept = thismonth.namadept
-----------------------------------------------
INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT
-----------------------------------------------
IndoPB - Indonesia PB User Group
To Post a message, send it to: [EMAIL PROTECTED]
To Unsubscribe,send a blank message to: [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indopb/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
