Oh, good, now it is easier to ask questions. Is Bank and AccountNo declared
as varchar or char or does any of them happen to be integer or even blob?

Set

>create view vDeps1 (DepID, Descr) as
>select d.DepID,
> cast(d.Bank||' '||d.AccountNo as varchar(64)) as Descr
>from DepRights r
> inner join departments d on r.DepID = d.DepID;
>
>select * from vDeps1
>________________
>0 rows