Helen wrote:

>This is a self-referencing table and the left outer self-join is based on a
>nullable link column. Therefore you are getting null outputs in all your
>orderingitems columns wherever a parent has no children. Get the output
>instead via a selectable stored procedure that returns emptystrings or
>zeroes (as applicable) in these null columns.

I updated IBO to the latest release (IBO_3_6_Ce_TEST2) and then it
worked. So I think it must have been a bug in IBO.

Regards
Helmut