Alan McDonald wrote:

>the second one is a copy of the view again - you sure you've given us the
>select onely code?
>

I'm sorry. Just copy beginning from "SELECT...":

> select d.DepID,
> cast(d.Bank||' '||d.AccountNo as varchar(64)) as Descr,
> cast(
> (select sum(p.total/p.rate) from pays p where p.dstid = d.subjid and
> p.depid = d.depid)
> as float) as TotalIn,
> cast(
> (select sum(p.total/p.rate) from pays p where p.srcid = d.subjid and
> p.depid = d.depid)
> as float) as TotalOut
> from DepRights r
> inner join departments d on r.DepID = d.DepID
> inner join employees e on r.SubjID = e.SubjID and e.Login = USER
>
>
>