select t.*, a.cognome, b.cognome, c.cognome from turni t, personale a, personale b, personale c where t.persona1=a.tessera and t.persona2=b.tessera and t.persona3=c.tessera and t.data=......