1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
| SELECT
Transaction.IDTransaction AS IDTransaction,
Transaction.Date_pret AS Date_pret,
Transaction.Date_retourReel AS Date_retourReel,
Transaction.Date_retour AS Date_retour,
Transaction.Affaire AS Affaire,
Transaction.Etat_retour AS Etat_retour,
Transaction.IDEmployéRetour AS IDEmployéRetour,
Type.Type AS Type,
Transaction.Etat_pret AS Etat_pret,
Transaction.Actu AS Actu,
Transaction.Type_modif AS Type_modif,
Transaction.Der_modif AS Der_modif,
Transaction.Code_barre AS Code_barre,
Transaction.CodeEtiquette AS Code_barreO,
Employé.Nom AS Nom,
Articles.Designation AS Designation
FROM
Transaction,
Articles,
Articles_serialises,
Type,
Employé
WHERE
Transaction.IDType=Type.IDType
AND Transaction.CodeEtiquette=Articles_serialises.CodeEtiquette
OR Transaction.CodeEtiquette=Articles.CodeConsommable
AND Articles_serialises.CodeArticle=Articles.CodeArticle
AND Transaction.Code_barre = Employé.Code_barre
AND
(
Transaction.Code_barre = {Param1}
AND Transaction.CodeEtiquette = {Param2}
AND Transaction.IDType = {Param3}
AND Transaction.Affaire LIKE %{Param4}%
AND Transaction.Date_pret BETWEEN {Param6} AND {Param7}
AND Transaction.Date_retourReel BETWEEN {Param8} AND {Param9}
AND Transaction.Der_modif <= {Param10}
) |
Partager