mungkin bisa membantu......
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
--
http://rikyandrian.blogspot.com <http://rikyandrian.blogspot.com/>
riky andrian
/*no better future than the processors...*/
-----------------------------------------------
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/
