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?
-----Original Message-----
From: Andrew Guts [mailto:andr@...]
Sent: Monday, 16 September 2002 22:50
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Please help. View is empty, but the same SELECT
works!


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.


Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]