necesito una mano con unas consultas de mysql

[gjx2]

Pues haz la unificacion con join
Podria ser algo como

Código PHP:

$varString = "SELECT $server_cdb.character_achievement.*,$server_mm.dbc_achievement.* 
FROM $server_cdb.character_achievement
JOIN $server_mm.dbc_achievement ON $server_mm.dbc_achievement.id = $server_cdb.character_achievement.id
WHERE $server_cdb.character_achievement.guid = 9
";
 
$dbUser = mysql_query($varString, $connection_setup) or die (mysql_error());
 
if (mysql_num_rows($dbUser)) {
        while ($db_sql = mysql_fetch_array($dbUser)) { 
        echo $dbSql["rewpoints"]."<br />"; 
        }
}
 

Saludos.