alias con join

[torrone]

c'è l'ho fatta

$sql3as = "SELECT *, la.user as l1, lb.user as l2 FROM tab JOIN user AS la ON la.iduser = tab.iduser1 JOIN user AS lb ON lb.iduser = tab.iduser2";
$query3as = mysql_query($sql3as);
while ($row3as = mysql_fetch_array($query3as)) {

    echo $row3as['l1'] . " --> " . $row3as['l2'] . "
";

} 

grazie milleee