>Ok,
>
>
>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.
>
>TIA
>Jeff
Jeff,
I am still confused, why only
id AssemblyID PartsId
4 1 2
in the Combined table you have
id AssemblyID PartsId
1 1 2
Why not include it in the result?
As far as I understand your combined table keeps AssemblyID of the ParentOne in AssemblyId field and PartsId of the ParentTwo in PartsId and you want the records which have no match in BOTH parent tables, is this right?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
