I have a forum that uses two tables. Parent and Child.<BR><BR>Each parent may have none or many children. The ParentID is the id that ties the two together. <BR><BR>I want to run a query to return a single parent and all it's children in one recordset where the first record is the parent (post, title) and the rest are it's children (child post, child title). <BR><BR>Is this possible?