como unir tablas de resultados

[gildus]

Holas,

Algo como:

Código PHP:

$arr1 = array();
$arr2 = array();
$r1 = mysql_query("SELECT id_a AS id, nom_a AS nom FROM aaa");
while($rw1 = mysql_fetch_array($r1))
    array_push($arr1,array("id"=>$rw1['id'],"nom"=>$rw1['nom']) );
 
 
 
$r2 = mysql_query("SELECT id_b AS id, nom_b AS nom FROM bbb");
while($rw2 = mysql_fetch_array($r2))
    array_push($arr2,array("id"=>$rw2['id'],"nom"=>$rw2['nom']) );
 
 
$result = array_merge((array)$arr1,(array)$arr2);
echo "ID  ----------  NOM<br>";
foreach($result as $campo){
    echo $campo['id']."  ----------  ".$campo['nom'];
    echo '<br>';
}
 

Ya tu lo acomodas a tu necesidad.

Saludos
Gildus