Assuming it is 5 fixed columns, you could try:
SELECT t1.Name, SUM(t2.col1+t2.col2+t2.col3+t2.col4+t2.col5) as sum
FROM t1, t2, t3
WHERE t1.id1 = t3.id1 AND t3.id2 = t2.id2
GROUP BY t2.id2
ORDER BY sum DESC
Also, i'm assuming that all entries in t1 have a correspondent in t3 and
t2.
On Sat,
Keith
Extranet
[EMAIL PROTECTED] - 08/02/2003 04:47
To:mysql
cc:
Subject: Help, Not sure my other email got through!
Not sure my other email got through, so here it is again, with an updated
description.
Hi,
I have a database with 3 names in it. In each of these names is 5
categor
Not sure my other email got through, so here it is again, with an updated
description of the problem.
Hi,
I have a database with 3 names in it. In each of these names is 5
categories that have numbers in them. I want to be able to do a select and
total these numbers for each name, and then sort
Not sure my other email got through, so here it is again, with an updated
description.
Hi,
I have a database with 3 names in it. In each of these names is 5
categories that have numbers in them. I want to be able to do a select and
total these numbers for each name, and then sort them in descen
