The problem doesn't occurs on Interbase only on Firebird.

Yes I can create a new View, however, this is not normal, it will
remove the possibility to use a view in a left join select.

--- In ib-support@y..., Thomas Miller <tmiller@b...> wrote:
> Form what I remember with IB 6 is that mixing views and tables in
join
> statements was
> very very slow. I would recommend making another view that
includes the
> additional
> table.
>
> Samy Song wrote:
>
> >Did anyone had this problem, I'm trying to do a select with a left
join on a
> >view with Firebird, also tested it on Interbase here is the case:
> >First select, contacts_view is a view with 3 tables left joined :
city,
> >province and country.
> >
> >
> >
>
> --
> Thomas Miller
> Delphi Client/Server Certified Developer
> BSS Accounting & Distribution Software
> BSS Enterprise Accounting FrameWork
>
> http://www.bss-software.com