Seleccion múltiple con errores

[gnavarro82]

quedo de esta forma

query = "select t1.codregistro,t1.fecha, t2.placa as Placa, t3.apellidos as chofer, t4.apellidos as lider, t5.apellidos as auxiliar from registroflota as t1
inner join unidad as t2 on (t1.cod_unidad = t2.codunidad)
inner join personal as t3 on (t1.cod_chofer = t3.codpersonal)
inner join personal as t4 on (t1.cod_lider = t4.codpersonal)
inner join personal as t5 on (t1.cod_auxiliar1 = t5.codpersonal)"

gracias chicos