ah, thanks a lot .. didn't know that it works that way

--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > 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