RE: [PHP] Averaging columns in two tables?

[Chadwick, Russell]

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]

[PHP] Averaging columns in two tables?

[Jeff Lewis]

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