Seleccion múltiple con errores

[Libras]

con ese query no lo vas a sacar, ocuparias algo como esto:

Código MySQL:

select t1.*, t2.apellido as chofer, t3.apellido as lider, t4.apellido as auxiliar from registroflota as t1
inner join personal as t2 on (t1.cod_chofer=t2.cod_personal)
inner join personal as t3 on (t1.cod_lider=t3.cod_personal)
inner join personal as t4 on (t1.cod_auxiliar1=t4.cod_personal)
 

error en el query no en la estructura