Svein Erling Tysvær wrote:

> Unlike some of us, neither Thomas nor Helen use to write something
> incorrect on this list. This time, I haven't got a clue who is right,
> but try this as a final test:
>
> create view View_name(Field1,. Fieldn )
> as select Field1, . Fieldn
> from Table1
> join Table2 on .
> left join SPname() on .
>
> Set
>

You are right Set.

To use SP's in views one should use left join to force it to be he last
on the stream join order.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br