Xref: alice comp.databases.oracle.misc:50268
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.novia.net.MISMATCH!novia!nntp3.cerf.net!news.powerisp.com!not-for-mail
From: Gabriel Millerd <millerd@ns1.rli-net.net>
Newsgroups: comp.databases.oracle.misc
Subject: Re: simple query help
Date: 1 Jan 2000 21:55:39 GMT
Organization: PowerUser Technologies
Lines: 19
Message-ID: <84lt4r$71g$1@news.powerisp.com>
References: <84do8m$blc$1@news.powerisp.com> <iysb4.7051$zp.105740@news3.mia>
X-Trace: news.powerisp.com 946763739 7216 207.112.238.1 (1 Jan 2000 21:55:39 GMT)
X-Complaints-To: abuse@poweruser.com
NNTP-Posting-Date: 1 Jan 2000 21:55:39 GMT
User-Agent: tin/pre-1.4-981002 ("Phobia") (UNIX) (Linux/2.2.5 (i686))

Wolf <wolf@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 |