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 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
SELECT distinct identifiant as MATRICULE,
nom as NOM,
prenom as PRENOM,
datnais as DATE_NAISSANCE,
lieu as LIEU_NAISSANCE,
RUE as RUE,
champs,
champs,
champs,,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs,
champs
FROM table1 t1
inner join .......
inner join .......
inner join .......
inner join .......
left outer join ....... and champs = to_date('2019-01-31','YYYY-MM-DD')
left outer join ....... and champs = to_date('2019-01-31','YYYY-MM-DD')
left outer join .......
left outer join .......
where condition= 0003; |
Partager