> > Then the first line with the <null> values are left out.
> >
> > I thought, that when I made an LEFT OUTER JOIN I would get every
> > record as in the first eventhough I put on a condition regarding
> > table T3.
>
> Not if the resulting T3 values don't match the WHERE clause.

Well, they don't.
I just thought, that when doing a left outer join, it would still
return the values below.
I would expect it to be the first with the null values.
But as you state, if the T3 values don't match the where clause, and
they don't then thats why !

Just annoying !

>
> > The result set should have been:
> >
> > 000010, 001, 111, <null>, <null>
> > 000010, 002, 222, 22, 43
> >
> > But it is:
> > 000010, 002, 222, 22, 43
> >
> >
> > I really would like to have to first line present as well !
>
> Well, we don't have the T3.AAR or T3.MDR data, so it's a bit
> hard to tell.

No, but I can produces a small DB if you would like !

Michael