Rien je pense :
SELECT label, designation, description, manufacturer, diagram_position, POSITION FROM element_nomenclature_view WHERE ( element_type = 'Terminale' OR element_type = 'Simple' OR element_sub_type = 'commutator' OR element_sub_type = 'coil' OR element_sub_type = 'protection') AND designation IS NOT NULL ORDER BY label, designation, description, manufacturer, diagram_position, POSITION
Je m'en sers juste pour éliminer les lignes vides de la nomenclature.