Let me do what I always do and suggest that you get a copy of TREES &
HIERARCHIES IN SQL for several better approachs for modeling this kind
of structure. Right now, you are destroying information with false
NULLs. What were you trying to do?