Re: Compare 2 resultsets of db-query

Analysis & Solutions wrote:

Hey Danny: On Mon, Jun 10, 2002 at 10:09:12PM +0200, Danny Kruitbosch wrote:

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 Now I want to print a table that prints the values of FIELD1, TOTAL and SUB. Query 1 returns more rows as query 2. Field1 is the same in both queries so I should be able to 'link' the results of both queries together.

I'm wondering exactly what you're trying to do. It may be possible to do in one well crafted query. Why limit the second query only to items where Field2 = 1? What's in FIELD1 and FIELD2? Also, I assume you want each row of your HTML table to have the FIELD1, TOTAL and SUB fields in them, right? --Dan

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.