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
On Wed, Jun 12, 2002 at 04:54:30PM +0200, Danny Kruitbosch wrote:
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
Analysis Solutions wrote:
On Wed, Jun 12, 2002 at 04:54:30PM +0200, Danny Kruitbosch wrote:
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
What you're asking is considered a UNION. I'm not sure which database
you're using, so I can't tell if it supports UNIONs or not. If you're using
MySQL, UNIONs are supported in version 4.0-alpha.
Another approach is storing the results of both queries in single array and
then pulling it from
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
5 matches
Mail list logo