1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
SELECT DISTINCT match.mat_date, nation.nat_nom, joue.nat_essai, joue.nat_trans,
joue.nat_penal, joue.nat_drop, nation2.nat_nom as nom_adv,
joue2.nat_essai as essai_adv, joue2.nat_trans as trans_adv,
joue2.nat_penal as penal_adv, joue2.nat_drop as drop_adv,
match.mat_stade, stade.sta_nom, stade.sta_ville, stade.sta_cap,
nation.nat_abr, nation.nat_poule
FROM
public.joue
INNER JOIN public.match ON match.mat_id = joue.mat_id
INNER JOIN public.nation ON nation.nat_id = joue.nat_id
INNER JOIN public.stade ON stade.sta_id = match.mat_stade
INNER JOIN public.joue joue2 ON joue.mat_id = joue2.mat_id
AND joue.nat_id <> joue2.nat_id
INNER JOIN public.nation nation2 ON joue2.nat_id = nation2.nat_id
WHERE nation.nat_poule = 'A'
ORDER BY match.mat_date; |
Partager