Risolto con:


$sql = "SELECT *, a.campo_da_confrontare AS campo1, b.campo_da_confrontare AS campo2 FROM tabellaA AS a, tabellaB AS b, WHERE a.id_autore=b.id_autore";