>combined >id AssemblyID PartsId >1 1 1 >1 1 2 >1 1 3 >2 1 1 >2 2 1 >2 2 2 >3 1 1 >3 2 1 >4 1 1 >4 1 2 > >ParentOne >id AssemblyID >1 1 >2 1 >2 2 >3 1 >3 2 >4 1 > > >ParentTwo >id PartsId >1 1 >1 2 >1 3 >2 1 >2 2 >3 1 >3 2 >4 1 > > >Desired result >id AssemblyID PartsId >4 1 2 >>Parent may have been a bad choice of words.
id AssemblyID PartsId 4 1 2in the Combined table you have
id AssemblyID PartsId 1 1 2Why not include it in the result?