Codice PHP:
$q1 mysql_query("
                           SELECT paure.paura
                           FROM ( paure INNER JOIN paure_persone ON idpaura INNER JOIN persone ON idpersona )
                           WHERE persone.nome = 'Mario Rossi'
                          "
) or die(mysql_error());

$q2 mysql_fetch_array($q1);

print 
$q2['paura']; 
errore:

Column 'idpaura' in on clause is ambiguous