get average score from 3 different tables

[raven1001]

Hi, I have a problem to combine 3 tables scores and get the average score of it. My example is as follow.

table 1

name score
mike 70
shane 80
john 80
sherly 90

table 2

name score
mike 66
sherly 90
john 33
shane 78

table 3

name score
mike 83
sherly 78
john 66
shane 90

final result or what I want is the average scored to be displayed from that 3 tables.

Name average score
mike 73
shane 82.7
sherly 86

how should I do that... pls help thanks

[bpat1434]

$query = "SELECT ROUND(((a.score+b.score+c.score)/3),1) AS average,
		a.name AS aName
		FROM `raven1001_1` AS a, 
		`raven1001_2` AS b, 
		`raven1001_3` AS c
		ORDER BY a.id ASC";

$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result))
{
   $scores[$row['aName']] = $row['average'];
}

foreach($scores as $name => $avg)
{
	echo 'Name: '.$name.'<br>
	Average: '.$avg.'<hr>';
}

~Brett