Thanks for the suggestion.
I did a left join as follows:
Code:
sb.Append(" from E_Ensemb e ")
sb.Append(" left join E_Ensart a on a.ENFANT = e.ITEM_NBR  ")
sb.Append("   where a.PARENT = '" & name & "'")
but still I get only one line instead of 2.

Please help.