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
loc_vac.LOC_ID AS LOC_ID,
loc_vac.LOC_CAP AS LOC_CAP,
loc_vac.LOC_CHA AS LOC_CHA,
loc_vac.LOC_EQPT_PISC AS LOC_EQPT_PISC,
loc_vac.LOC_EQPT_JARD AS LOC_EQPT_JARD,
loc_vac.LOC_EQPT_PARK AS LOC_EQPT_PARK,
loc_vac.LOC_ACC_ANIM AS LOC_ACC_ANIM,
loc_vac.LOC_ACC_HAND AS LOC_ACC_HAND,
loc_vac.LOC_PAYS AS LOC_PAYS,
loc_vac.LOC_REG AS LOC_REG,
loc_vac.LOC_DEPT AS LOC_DEPT,
loc_vac.LOC_VILLE AS LOC_VILLE,
loc_vac.LOC_VAC_LIGNE AS LOC_VAC_LIGNE,
loc_vac.LOC_DATE_FIN_UNE AS LOC_DATE_FIN_UNE,
type_loc_cat.TYPE_LOC_CAT_LIB AS TYPE_LOC_CAT_LIB,
type_loc_sscat.TYPE_LOC_SSCAT_LIB AS TYPE_LOC_SSCAT_LIB
FROM
type_loc_sscat RIGHT OUTER JOIN loc_vac ON loc_vac.FK_TYPE_LOC_SSCAT_ID = type_loc_sscat.TYPE_LOC_SSCAT_ID,
type_loc_cat INNER JOIN loc_vac ON loc_vac.FK_TYPE_LOC_CAT_ID = type_loc_cat.TYPE_LOC_CAT_ID
WHERE
(
type_loc_cat.TYPE_LOC_CAT_LIB = {PARAM_TYPE}
AND loc_vac.LOC_CAP >= {PARAM_PERS}
AND loc_vac.LOC_CHA >= {PARAM_CHA}
AND loc_vac.LOC_EQPT_PISC = {PARAM_OPT_PISC}
AND loc_vac.LOC_EQPT_JARD = {PARAM_OPT_JARD}
AND loc_vac.LOC_EQPT_PARK = {PARAM_OPT_PARK}
AND loc_vac.LOC_ACC_ANIM = {PARAM_OPT_ANIM}
AND loc_vac.LOC_ACC_HAND = {PARAM_OPT_HAND}
AND loc_vac.LOC_PAYS = {PARAM_PAYS}
AND loc_vac.LOC_REG = {PARAM_REG}
AND loc_vac.LOC_DEPT = {PARAM_DEP}
AND loc_vac.LOC_VILLE = {PARAM_VILLE}
AND loc_vac.LOC_VAC_LIGNE = 1
AND loc_vac.LOC_DATE_FIN_UNE >= {PARAM_DATE_UNE}
AND type_loc_sscat.TYPE_LOC_SSCAT_LIB = {PARAM_SOUS_TYPE}
) |
Partager