hierarchical query join test added