ah ha. if the left outer join is made the last table in the query it
works right - must not be before !!!!

;={

--- In firebird-support@yahoogroups.com, "rayholme" <rayholme@y...> wrote:
>
> Sorry to say a left outer join of a table with a procedure returning
> mulltiple roles does not do what it should.
>
> One only gets one row out here where we should be multiple.
>
> This is true in IB 6, IB 7 and Firebird 1.0.3 as well as 1.5.2 so we
> are not alone.
>
> Ray