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
| SELECT INSCRIPTION.ins_no, INSCRIPTION.ins_date,
STAGE.stg_code, Sum(PAYER.pay_mnt) AS prix_paye,
SEJTHEMATIQUE.sejthem_lib, STAGE.stg_date_deb,
STAGE.stg_date_fin,
=> inconnu du SQL : STAGE!stg_px_sem1+TRANSPORTS!tra_px_voy+TRANSPORTS_1!tra_px_voy-INSCRIPTION!ins_reduc+IIf(INSCRIPTION!ins_assurance=True,IIf(STAGE!stg_date_deb>#6/15/2006#,25,20),0) AS [prix public]
FROM STAGE
RIGHT OUTER JOIN INSCRIPTION
ON STAGE.stg_no = INSCRIPTION.ins_stg_no
INNER JOIN PAYER
ON PAYER.pay_ins_no = INSCRIPTION.ins_no
LEFT OUTER JOIN SEJTHEMATIQUE
ON STAGE.stg_thema_no = SEJTHEMATIQUE.sejthem_no
INNER JOIN TRANSPORTS
ON INSCRIPTION.ins_tr_aller = TRANSPORTS.tra_no
INNER JOIN TRANSPORTS AS TRANSPORTS_1
ON INSCRIPTION.ins_tr_retour = TRANSPORTS_1.tra_no
WHERE INSCRIPTION.ins_enf_no => inconnu du SQL = ".$numero."
GROUP BY INSCRIPTION.ins_enf_no, INSCRIPTION.ins_no,
INSCRIPTION.ins_date, STAGE.stg_code,
SEJTHEMATIQUE.sejthem_lib, STAGE.stg_date_deb,
STAGE.stg_date_fin,
=> inconnu du SQL STAGE!stg_px_sem1+TRANSPORTS!tra_px_voy+TRANSPORTS_1!tra_px_voy-INSCRIPTION!ins_reduc+IIf(INSCRIPTION!ins_assurance=True,IIf(STAGE!stg_date_deb>#6/15/2006#,25,20),0)
ORDER BY INSCRIPTION.ins_date DESC |
Partager