Re: Compare 2 resultsets of db-query
| From: | Danny Kruitbosch | Date: | Wed, 12 Jun 2002 20:36:35 +0000 |
| Subject: | Re: Compare 2 resultsets of db-query | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-101810@lists.php.net to get a copy of this message | ||
Analysis & Solutions wrote:
On Wed, Jun 12, 2002 at 04:54:30PM +0200, Danny Kruitbosch wrote:Thanks! Sometimes the obvious is the last thing you think about.... DannyAnalysis & Solutions wrote:0 and 1 in FIELD2? That makes this a piece of cake! All you need is one query. In Query1, do a SUM(FIELD2) rather than COUNT(FIELD2). Forget about Query2. --DanHey Danny: On Mon, Jun 10, 2002 at 10:09:12PM +0200, Danny Kruitbosch wrote:FIELD 1 contains IP address pool names (not unique), field2 the status (0 free, 1 leased). So what I try to do is get an overview of the total number of IP adresses in a pool and the number of leased addresses. There's a fourth field that contains the actual address.Query1: SELECT FIELD1, COUNT(FIELD2) AS TOTAL from TABLE GROUP BY FIELD1 Query2: SELECT FIELD1, COUNT(FIELD2) AS SUB from TABLE WHERE FIELD2=1 GROUP BY FIELD1