RE: [PHP] Averaging columns in two tables?
| From: | Chadwick, Russell | Date: | Wed, 11 Jul 2001 18:27:20 +0000 |
| Subject: | RE: [PHP] Averaging columns in two tables? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-57461@lists.php.net to get a copy of this message | ||
SELECT round((hitters.age+pitchers.age) / 2) as avg_age
...
-----Original Message-----
From: Jeff Lewis [mailto:jeff@hyrum.net]
Sent: Wednesday, July 11, 2001 11:25 AM
To: php-general@lists.php.net
Subject: [PHP] Averaging columns in two tables?
Is it possible to get the average of two tables. I have an age column in
two tables. I can get the age average for one table both can the average of
both tables be found in one statement? One table is for hitters, the other
for pitchers.
Jeff