Alan McDonald wrote:

>can you try these without the cast
>and with just a where instead of join
>to see what happens
>create view vDeps2(DepID, Descr) as
>select d.DepID, d.Bank||' '||d.AccountNo Descr
>from DepRights r, departments d where r.DepID = d.DepID
>
>and
>select d.DepID, d.Bank||' '||d.AccountNo Descr
>from DepRights r, departments d where r.DepID = d.DepID
>
>
>

The same odd thing. View is still empty.