1 2 3 4 5 6 7 8 9 10 11 12 13
| select "lundi" as 'jour', petit_dejeuner, dejeuner, diner from base_contenu left outer join base_programme on ( base_contenu.id = base_programme.j1 ) where base_programme.code_semaine = "s1"
union
select "mardi" as 'jour', petit_dejeuner, dejeuner, diner from base_contenu left outer join base_programme on ( base_contenu.id = base_programme.j2 ) where base_programme.code_semaine = "s1"
union
select "mercredi" as 'jour', petit_dejeuner, dejeuner, diner from base_contenu left outer join base_programme on ( base_contenu.id = base_programme.j3 ) where base_programme.code_semaine = "s1"
union
select "jeudi" as 'jour', petit_dejeuner, dejeuner, diner from base_contenu left outer join base_programme on ( base_contenu.id = base_programme.j4 ) where base_programme.code_semaine = "s1"
union
select "vendredi" as 'jour', petit_dejeuner, dejeuner, diner from base_contenu left outer join base_programme on ( base_contenu.id = base_programme.j5 ) where base_programme.code_semaine = "s1"
union
select "samedi" as 'jour', petit_dejeuner, dejeuner, diner from base_contenu left outer join base_programme on ( base_contenu.id = base_programme.j6 ) where base_programme.code_semaine = "s1"
union
select "dimanche" as 'jour', petit_dejeuner, dejeuner, diner from base_contenu left outer join base_programme on ( base_contenu.id = base_programme.j7 ) where base_programme.code_semaine = "s1" |
Partager