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
| SELECT
c.code code_clie,
c.libe nom_clie,
bvisite.udate Bon_visite,
accept.udate Acceptation,
refu.udate Refu_apres_visite,
appro.udate Approbation,
creserv.udate Contrat_reserv,
tagence.udate Trans_agence,
cbail.udate Creation_bail
FROM
client c, evenement ev,
(SELECT code, udate from evenement where refe = '1203' AND code = '123456') bvisite, --Emission bon de visite
(SELECT code, udate from evenement where refe = '1202' AND code = '123456') accept, --Acceptation après visite
(SELECT code, udate from evenement where refe = '1204' AND code = '123456') refu, --Refu après visite
(SELECT code, udate from evenement where refe = '1211' AND code = '123456') appro, --Approbation
(SELECT code, udate from evenement where refe = '1311' AND code = '123456') creserv, --signature contrat de reservation
(SELECT code, udate from evenement where refe = '1208' AND code = '123456') tagence, --Transfert agence
(SELECT code, udate from evenement where refe = '0200' AND code = '123456') cbail --Creation du bail
WHERE
c.code = ev.code
AND c.role = '1'
AND ev.code = '123456'
AND ev.code = bvisite.code AND ev.code = accept.code AND ev.code = refu.code AND ev.code = appro.code AND ev.code = creserv.code AND ev.code = tagence.code AND ev.code = cbail.code
; |
Partager