Hi Michael,

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

Sure - go ahead and I'll give it a try.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com