1 2 3 4 5 6 7 8 9
| SELECT t_contrat.contrat_num, t_contrat.contrat_datecreation, param1.param_texte, param2.param_texte, param3.param_texte, t_enseignement.Intitulé_enseigmt
FROM t_contrat, t_param AS param1, t_param AS param2, t_param AS param3, t_enseignement
WHERE param1.param_code=t_contrat.contrat_type And param2.param_code=t_contrat.contrat_categorie And param3.param_code=t_contrat.contrat_etat and t_enseignement.enseignement_num=t_contrat.contrat_numenseignement order by t_contrat.contrat_datecreation
UNION
SELECT t_contrat.contrat_num, t_contrat.contrat_datecreation, param1.param_texte, param2.param_texte, param3.param_texte, t_contrat.contrat_numenseignement
FROM t_contrat, t_param AS param1, t_param AS param2, t_param AS param3
WHERE param1.param_code=t_contrat.contrat_type And param2.param_code=t_contrat.contrat_categorie And param3.param_code=t_contrat.contrat_etat and t_contrat.contrat_numenseignement is null order by t_contrat.contrat_datecreation; |
Partager