Displaying parent nodes with child nodes - nested views, hard coding, or other approach? I have a parent content type which is categorized with a taxonomy term. Then there are child nodes to the parent. When someone clicks on a category, I want them to see a table basically. It would be of the form:


  Parent1
  Description
  
  
    Child1
      Description
    
    Child2
      Description
  
  
  Parent2
  etc


Seems out of the box I can't get Views to behave that way, so I was thinking I would have one view that is for the Parents, and another for children of a parent, and then somehow (via Display Suite for instance) have the page display the views one after another. Though I suspect that way of thinking is counter to what drupal is all about, so I am really trying to harnass the power of drupal to make that happen, as opposed to writing a custom module (though in the end I think such a custom module would be easier than Views, but I want to max out my understanding of Views before I go that route).

That said, how would you go about creating the Views and then controlling the display in Display Suite?

EDIT: So I figured out the SQL query that would return the results how I want them. Basically something like this

SELECT n.title, d.field_description_value, n.nid, l.field_lesson_target_id from drupal_node n

JOIN drupal_field_data_field_description AS d ON d.entity_id = n.nid

JOIN drupal_taxonomy_index AS t ON t.nid = n.nid

LEFT JOIN drupal_field_data_field_lesson AS l ON l.entity_id = n.nid

ORDER BY COALESCE(l.field_lesson_target_id, n.nid), l.field_lesson_target_id, n.nid


I made sqlfiddle

So I guess it comes down to whether Views is able to produce such queries.
Per the creator, the answer is in the comments with some additional documentation here: http://drupaleasy.com/blogs/ultimike/2009/02/displaying-hierarchical-content