. Of
course, if the dataset is large enough, the temporary table will hit the
disc, and then it will be very inefficent though.
Thanks,
Mike
-Original Message-
From: John McCaskey [mailto:[EMAIL PROTECTED]
Sent: 24 February 2004 17:08
To: [EMAIL PROTECTED]
Subject: RE: GROUP BY across UNION
about that before.
Thanks,
John A. McCaskey
-Original Message-
From: Michael McTernan [mailto:[EMAIL PROTECTED]
Sent: Friday, June 18, 2004 11:16 AM
To: John McCaskey
Cc: [EMAIL PROTECTED]
Subject: RE: GROUP BY across UNION
Hi John,
Depending on the size of your datasets, you could
]
Fax to:
06/18/2004 02:15 Subject: RE: GROUP BY across UNION
PM
the values and computing them in code. Very sub optimal.
John A. McCaskey
-Original Message-
From: Ligaya Turmelle [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 18, 2004 6:30 PM
To: [EMAIL PROTECTED]
Subject: Re: GROUP BY across UNION
I am pretty new myself but can't you do
First of all I am using mysql 4.0.18 and I am not free to upgrade to 4.1
or 5.0.
I have two tables:
table_a, and table_b these two tables have the same structure:
CREATE table_a (
id_field mediumint(8) unsigned NOT NULL,
avg float default NULL
)
What I want to do is get the
I am pretty new myself but can't you do it with a join? Like SELECT AVG(avg)
FROM table_a, table_b GROUP BY id_field.
Respectfully,
Ligaya Turmelle
John McCaskey [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
First of all I am using mysql 4.0.18 and I am not free to upgrade to 4.1
or