> Hi,
>
> sorry maybe I misworded it.
>
> I just have one table with the volume column and I'd like to do only
> one select statement that gives me both the averages for the negative
> volume numbers and the positive numbers which reside in the same column
>

SELECT (select avg(old_salary) from salary_history where old_salary>0)
avgsal from RDB$DATABASE

you might get the drift

Alan