1 2 3 4 5 6 7 8 9
|
SELECT J1.équipement, J1.date_de_signature, "Quality assurance plan " as libelle, format(J1.[Quality assurance plan J1],"mm/yyyy") AS date_théorique, format(J1.[Quality assurance plan J1Date réelle],"mm/yyyy") AS date_réelle, format(J1.[Quality assurance plan J1Date d'analyse],"mm/yyyy") as date_d_analyse FROM J1
UNION ALL
SELECT J1.équipement, J1.date_de_signature, "Conformity (compliance) matrix" as libelle, format(J1.[Conformity (compliance) matrix J1],"mm/yyyy") as date_théorique, format(J1.[Conformity (compliance) matrix J1Date réelle],"mm/yyyy") as date_réelle, format(J1.[Conformity (compliance) matrix J1Date d'analyse],"mm/yyyy") AS date_d_analyse FROM J1
UNION ALL
....
UNION ALL
SELECT J1.équipement, J1.date_de_signature, "Overall dimension AND interface drawing" as libelle, format(J1.[Overall dimension AND interface drawing J1],"mm/yyyy") AS date_théorique, format(J1.[Overall dimension AND interface drawing J1Date réelle],"mm/yyyy") AS date_réelle, format(J1.[Overall dimension AND interface drawing J1Date d'analyse],"mm/yyyy") as date_d_analyse FROM J1
|
Partager