SELECT round((hitters.age+pitchers.age) / 2) as avg_age
...
-----Original Message-----
From: Jeff Lewis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 11, 2001 11:25 AM
To: [EMAIL PROTECTED]
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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]