Re: simple query help

Wolf <wolf_at_mrsoxx.com> wrote:
> 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
> /

        Wow, thanks

---

Gabriel Millerd        |   I would never lie. I willingly participated in a
RLI Internet Services  |   campaign of misinformation.  -Fox Mulder, XFiles
System Admin Attribu   |                      "Shadows"
http://www.rli-net.net |