INNER JOIN

[stabi]

usa php!

$old="";
while( $sRow = mysql_fetch_array($ .....))
{
 if( $old <> $sRow['cognome'] ){
        echo '
'.$sRow['cognome']. ' ' .$sRow['nome'];
        $old=$sRow['cognome'];
 }
 echo $sRow['tipo_acquisto']. ' ';
}