1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| select ART.code
, ART.libelle
, RUB1.val as couleur
, RUB2.Val as taille
, RUB3.val as pays
from article as ART
left outer join rubrique as RUB1
on RUB1.entite = 'ARTICLE'
and RUB1.code_entite = ART.code
and RUB1.code_rubrique = 'COULEUR'
left outer join rubrique as RUB2
on RUB1.entite = 'ARTICLE'
and RUB1.code_entite = ART.code
and RUB1.code_rubrique = 'TAILLE'
left outer join rubrique as RUB3
on RUB1.entite = 'ARTICLE'
and RUB1.code_entite = ART.code
and RUB1.code_rubrique = 'PAYS' |
Partager