Re: simple query help

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 3 Jan 2000 15:11:11 GMT
Message-ID: <84qe6f$o1a$2@news.seed.net.tw>

Wolf <wolf_at_mrsoxx.com> wrote in message news:iysb4.7051$zp.105740_at_news3.mia...
> select a.dept, a.active, b.inactive
> from
> (select dept, count(*) active from <table> where status = 'a' group by
> dept) a,
> (select dept, count(*) inactive from <table> where status = 'i' group by
> dept) b
> where
> a.dept = b.dept

No. This is not correct.
If there are some depts without both active and inactive status, these depts will not be listed. Received on Mon Jan 03 2000 - 09:11:11 CST