select mop.sigla, mop.descrizione from modalita_pagamento mop inner join banche_join bjo on bjo.modalita = mop.sigla where (bjo.iban is null or bjo.iban = '') union select sigla, descrizione from modalita_pagamento where sigla not in (select distinct modalita from banche_join) and nascosto = 0 order by descrizione select * from banche where nascosto = 0 order by banca, descrizione