Hi all.

As You can see, better than me, below I have a snip from a procedure:

select count(*) from v_avanzamento_pratica where
( datagara between :tdal and :tal ) and
( ditta_aggiudicataria <> '' )
into quante_so;
select count(*) from v_avanzamento_pratica where
( datagara between :tdal and :tal ) and
( ditta_aggiudicataria <> '' ) and
( data_consegna_seggio is not null)
into consegnate_seggio;

The above count how many records meet the condition:
( datagara between :tdal and :tal ) and
( ditta_aggiudicataria <> '' )

The second query meet the same condition plus:
( data_consegna_seggio is not null )

Please, boy: there is a way to merge the two select?

Thanks, Ciao
Tony