kalau punya table yang memuat seluruh departemen yang ada, bisa
menggunakan query:
select
x.dept, a.P, b.L
from
(
departemen x
left join
(
select
dept, count(*) as P
from
karyawan
where
sex = 'P'
group by
dept
) a
on x.dept = a.dept
) y
left join
(
select
dept, count(*) as L
from
karyawan
where
sex = 'L'
group by
dept
) b
on y.dept = b.dept
btw, saya kurang yakin apa syntaxnya udah bener... tapi kira2 konsepnya
seperti itu... hope will be helpfull...
On Sat, 2004-12-18 at 16:32 +0700, NgebrakCity wrote:
> terimakasih atas pencerahannya
> tapi maaf saya pakai mysql dan ternyata full outer join nggak di dukung ama
> mysql gimana yah
> solusinya, ada yang tau triknya buat ngatasin full outer join?udah gogling
> tapi masih pusing
> thanks
>
> > select
> > a.dept, a.P, b.L
> > from
> > (
> > select
> > dept, count(*) as P
> > from
> > karyawan
> > where
> > sex = 'P'
> > group by
> > dept
> > ) a
> > full outer join
> > (
> > select
> > dept, count(*) as L
> > from
> > karyawan
> > where
> > sex = 'L'
> > group by
> > dept
> > ) b
> > on
> > a.dept = b.dept
> >
> > Semoga membantu...
--
Berhenti langganan: [EMAIL PROTECTED]
Arsip dan info: http://linux.or.id/milis.php
