Select T1.design_param as designparam1, T2.design_param as designparam2, T3.design_param as designparam3 From parametrage T1, parametrage T2, parametrage T3 Where // ici, une combinaison de conditions pour sélectionner // les lignes; une combinaison pour chacune des T1, T2 et T3 // par exemple : T1.id_param = 4012 And T2.id_param = 4012 And T3.id_param = 4012
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSelect T1.design_param as designparam1, T2.design_param as designparam2, T3.design_param as designparam3, T4.design_param as designparam4, T5.design_param as designparam5, T6.design_param as designparam6, T7.design_param as designparam7, T8.design_param as designparam8, T9.design_param as designparam9, T10.design_param as designparam10, nomination_classe From parametrage T1, parametrage T2, parametrage T3, parametrage T4, parametrage T5, parametrage T6, parametrage T7, parametrage T8, parametrage T9, parametrage T10, classe, option_param_classe Where T1.id_param = option_param_classe.id_param and T2.id_param = option_param_classe.id_param and T3.id_param = option_param_classe.id_param and T4.id_param = option_param_classe.id_param and T5.id_param = option_param_classe.id_param and T6.id_param = option_param_classe.id_param and T7.id_param = option_param_classe.id_param and T8.id_param = option_param_classe.id_param and T9.id_param = option_param_classe.id_param and T10.id_param = option_param_classe.id_param and option_param_classe.id_classe = classe.id_classe and T1.design_param = 'Classe papier' And T2.design_param = 'Peliculage' and T3.design_param = 'Couleur papier' and T4.design_param = 'Couleur impression' and T5.design_param = 'Grammage' and T6.design_param = 'choix' and T7.design_param = 'format' and T8.design_param = 'format final' and T9.design_param = 'Mesure/kg dans la bobine' and T10.design_param = 'NULL' and option_param_classe.id_classe = 1 and nomination_classe = 'Flyers standard'Déjà plus lisible ainsi.