--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> "That does not compute". An outer join will get ALL of the persons,
> whether employees or not.

This is exactly my goal! I want all persons and if the perons is an
employee i want additional infos from the employee table.

> I bet my best bottle of Scotch that an outer join is NOT what you want.

Huh I would like it :)

> But, again, the personlistid STILL seems the wrong thing to use to

select

> members of the the person or employee tables...unless perhaps

personlistid

> is where you keep only "current persons", or something.

User should be able to put some persons into a personlist for his
purpose. I.e. his team members or something.

Regards

Francois