> From: Mark Patterson
> > I meant to write LEFT OUTER JOIN, not LEFT JOIN.
>
> Thanks, I experiment with that when I get a free moment.

Just to save your time by eliminating redundant experimements:
LEFT OUTER JOIN and LEFT JOIN are exactly the same.
OUTER has no meaning, except making the command nicer.

Ivan
http://www.volny.cz/iprenosil/interbase