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