Join problemer

Jeg har et problem med at joine to tabeller, de har samme kolonner men ved SUM, tror går det galt, den tæller nemlig alt sammen, kode lige nu:

...
$day = date('N');
$lastday = date('N') + 1;
if ($day == 7) {
                      $lastday = 1;
}

$query = "SELECT travian_com_".$day.".travian_alliance_name, travian_com_".$day.".travian_player_id, travian_com_".$day.".travian_alliance_id, travian_com_".$day.".travian_player_name_6 AS name, COUNT(travian_com_".$day.".travian_village_id) AS count_vid, SUM(travian_com_".$day.".travian_population_6) AS sum_pop, SUM(travian_com_5.travian_population_5) AS sum_pop2, travian_com_5.travian_player_name_5
FROM travian_com_5, travian_com_".$day."
GROUP BY name
ORDER BY sum_pop DESC";
$today = $row['sum_pop'];
$staday = $row['sum_pop2'];

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

// Print out result

echo "<table border='1' class= 'Style1' style='border-collapse: collapse' bordercolor='#C0C0C0'>
<tr>
<th background='table.gif'>Plads</th>
<th background='table.gif'>Spiller</th>
<th background='table.gif'>Alliance</th>
<th background='table.gif'>Byer</th>
<th background='table.gif'>Indbyggere</th>
<th background='table.gif'>Op/ned</th>
</tr>";

$ud = $today - $staday;

$plads = 0;

while ($row = mysql_fetch_array($result)) {
    $plads++;
    echo "<tr vertical-align='center'>";
    echo "<td>$plads.</td>";
    echo "<td><a href='http://www.traviannews.dk/sta3.php?pid=" . $row['travian_player_id'] . "'>" . $row['name'] . "</a></td>";
    echo "<td><a href='http://www.traviannews.dk/sta2.php?aid=" . $row['travian_alliance_id'] . "'>" . $row['travian_alliance_name'] . "</a></td>";
    echo "<td>" . $row['count_vid'] . "</td>";
    echo "<td>" . $row['sum_pop'] . "</td>";
    echo "<td>$ud</td>";
    echo "</tr>";
}
echo "</table>";

mysql_close($con);
?><p class="style1">Lavet af Sæl med hjælp fra Snogard</p>
</div>


hvordan kan jeg få de til at virke?