Join af tabeller i select, men hvordan skille variabler bagefter?

SELECT a.body as frikadeller, b.body as cykelhjelme ....

Dvs. lav dine egne navne

Kan godt huske det, nu jeg ser det, har brugt det før, men åbenbart ikke nok!

Nej, åbenbart ikke nok ---
Kan man skrive således, synes ikke det virker:

$result = mysql_query( "SELECT thread.s AS s_thread, author.s AS s_author, thread.b AS b_thread, body.b AS b_body
FROM arr AS s, arr_body AS b
WHERE s_author = 'Nielsen' AND s_thread = b_thread");

while ($row = mysql_fetch_array($result)) {   

    $s_author = $row["s_author"];
    $s_thread = $row["s_thread"];
    $b_thread = $row["b_thread"];
    $b_body  = $row["b_body"];
   
    echo "$b_body<br>\n";
   
}

Nu har jeg fundet ud af det:

$result = mysql_query( "SELECT
s.thread AS s_thread,
s.author AS s_author,
s.parent AS s_parent,
z.thread AS z_thread,
z.body AS z_body
FROM
sociale_arrangementer AS s,
sociale_arrangementer_bodies AS z
WHERE
s.author = 'Nielsen'    //kan ikke tale alias her
AND s.parent = '0'
AND s.thread = z.thread
");

while ($row = mysql_fetch_array($result)) {   

    $s_thread = $row["s_thread"]; //alias kun her
    $s_author = $row["s_author"];
    $s_parent = $row["s_parent"];
    $z_thread = $row["z.thread"];
    $z_body  = $row["z_body"];
   
    echo "$z_body<br><br>\n";
   
}

?>