Subject Re: [ib-support] Please help. View is empty, but the same SELECT works!
Author Andrew Guts
Alan McDonald wrote:

>and this
>
>
>>create view vDeps2(DepID, Descr) as
>>select d.DepID, d.Bank Descr
>>
>>
>>from DepRights r, departments d where r.DepID = d.DepID
>
>
>>and
>>select d.DepID, d.Bank Descr
>>
>>
>>from DepRights r, departments d where r.DepID = d.DepID
>gives also empty view?
>
Yep.