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
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.


PHP General Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to