Erreur majeure*0x80040E14, erreur mineure*25501
> SELECT *, CASE WHEN type_transport = 'FRET' THEN 'T' ELSE 'ST' END AS unite,
CASE WHEN p.solde = 1 THEN 'OUI' ELSE 'NON' END AS solde2,
(SELECT designation + '<br>' + adresse1 + '<br>'+ adresse2 + '<br>' + code_postal +' '+ ville
+'<br>'+ pays +'<br>horaires : '+ horaires FROM str_adresses a3, str_clients c3
WHERE c3.id_adresse=a3.id_adresse AND a3.id_adresse=omd.id_expediteur) as expediteur,
(SELECT designation + '<br>' + adresse1 + '<br>'+ adresse2 + '<br>' + code_postal +' '+ ville
+'<br>'+ pays +'<br>horaires : '+ horaires FROM str_adresses a2, str_clients c2
WHERE c2.id_adresse=a2.id_adresse AND a2.id_adresse=omd.id_destinataire) as destinataire,
omd.quantite as qte_mission, omd.charge AS charge_mission,
CASE WHEN Pefc=1 THEN 'OUI' ELSE 'NON' END AS PilePefc
FROM str_piles p, str_chantiers c, str_ordre_mission_details omd, str_ordre_mission om
WHERE p.id_chantier=c.id_chantier AND p.id_pile=omd.id_pile AND om.id_ordre_mission=omd.id_ordre_mission
AND om.solde=0 AND om.type_mission!='FRET' AND
om.id_chauffeur = '4f02bcec-63cc-4fc3-9260-9210adb564dd' ORDER BY num
Une erreur s'est produite lors de l'analyse de la requête. [ Token line number = 3,Token line offset = 3,Token in error = SELECT ]
Partager