Thanks for your answer. Additionally, i want to a add a column with a flag if that row has a child, as the attached picture (final table)