Erreur SQL, requete : select THE.ITHE ithe, THE.LTHE lthe, THE.LATHE lathe, RESPONSABLE1.PRENOM r1_prenom, RESPONSABLE1.NOM r1_nom, RESPONSABLE2.PRENOM r2_prenom, RESPONSABLE2.NOM r2_nom, RESPONSABLE3.PRENOM r3_prenom, RESPONSABLE3.NOM r3_nom, LAB.ITLAB itlab, LAB.ILAB ilab, LAB.LLAB llab, LAB.LOC loc, LAB.ADRESSE adresse, LAB.NUMVOIE numvoie, LAB.NOMVOIE nomvoie, LAB.COMPLEMENT complement, LAB.CODPOST codpost, LAB.VILLE ville, LAB.CEDEX cedex, LAB.TEL1 tel1, LAB.TEL2 tel2, LAB.FAX fax, LAB.EMAIL email, LAB.EMAIL2 email2, DIRECTEUR.PRENOM d_prenom, DIRECTEUR.NOM d_nom from THE join LAB join PE DIRECTEUR on DIRECTEUR.IAN = LAB.IAN and DIRECTEUR.IPE = LAB.IPE on LAB.IAN = THE.IAN and LAB.ITLAB = THE.ITLAB and LAB.ILAB = THE.ILAB left outer join THEPE THEPE1 join PE RESPONSABLE1 on RESPONSABLE1.IAN = THEPE1.IAN and RESPONSABLE1.IPE = THEPE1.IPE on THEPE1.IAN = THE.IAN and THEPE1.ITHE = THE.ITHE and THEPE1.ITLAB = THE.ITLAB and THEPE1.ILAB = THE.ILAB and THEPE1.NTHEPE = 1 left outer join THEPE THEPE2 join PE RESPONSABLE2 on RESPONSABLE2.IAN = THEPE2.IAN and RESPONSABLE2.IPE = THEPE2.IPE on THEPE2.IAN = THE.IAN and THEPE2.ITHE = THE.ITHE and THEPE2.ITLAB = THE.ITLAB and THEPE2.ILAB = THE.ILAB and THEPE2.NTHEPE = 2 left outer join THEPE THEPE3 join PE RESPONSABLE3 on RESPONSABLE3.IAN = THEPE3.IAN and RESPONSABLE3.IPE = THEPE3.IPE on THEPE3.IAN = THE.IAN and THEPE3.ITHE = THE.ITHE and THEPE3.ITLAB = THE.ITLAB and THEPE3.ILAB = THE.ILAB and THEPE3.NTHEPE = 3 where THE.IAN = 2019 and THE.ITHE = '01' and THE.ITLAB = 'U' and THE.ILAB = '000986'

Equipe/Activité


Numéro :  01
Intitulé en français : 
Intitulé en anglais : 
 
Instituts thématiques :    
 
Responsable(s) : 
 
Structure concernée : 
 
 
 
Téléphone : 
Télécopie : 
E-mail de la structure : 
E-mail du responsable : 
 
Directeur :