Hello Alexandre,

ABS> You are right Set.
ABS> To use SP's in views one should use left join to force it to be he last
ABS> on the stream join order.

In this particular case there is no need to left join the SP: it has
no input parameters, which refer to the joined tables, so the join
order is not so important.

And Luis, it seems that I was wrong: FB doesn't like parenthesis when
there are no input parameters (at least, in SELECT statement).


--
Best regards,
Pavel Menshchikov
http://www.ls-software.com