0 - 1 of 1 tags for relationship table

Hi,

 

I need to traverse a "Relationship Table" using a "Recursive Query". An example follows. My actual business problem is far more complicated than this example. However, the required logic should be similar to the following.