title: Querying for all possible subparts of a part
body: <p>I have two tables in an Access database, one containing parts and subparts and the other to store the relations between these part. The part relations table has a field for the parent part and another for the subpart. With these two tables, I can have subparts with subparts, subparts associated multiple parent parts, and (obviously) parent parts with multiple sub parts.</p>
  
  <p>What I want to be able to do, using just a SQL statement, is bring up all of the subparts (and all of their subparts) of a single parent part. Is there a way to do this without putting any limits on how many levels deep of subparts the query can draw up? </p>