Definitively, I think you can't use stored procedure in a join in view
definition, with or without parenthesis, with or without a left clause.

Luis M. Molinero
Las Rozas - Madrid (Spain)
--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@...> wrote:

>
> 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
>