Apologize in advance for not seeing the obvious query to get the result set I need, but a picture is worth...
Thanks for your advice.
I cannot see how this is possible. The keys of the Name table (nameId, ownerId) are unrelated to those of the Spouse table (familyId, husbandId, wifeId).
Thank you for your observation.
I was sure that NameID (4000 individuals) in the Name Table equaled HusbandIDs (2000) & WifeIDs (2000) from the junction table. However, when I ran a simple query listing all, I realized that the junction table has bad data- no use at all.
So I'm creating a new DB starting with one main table with all clean records.
As long as your reading this, inserting values from DB1 ( #Request.BaseDSN1#)/existing table to DB2 (#Request.BaseDSN2#)/new table- can one do something like:
<CFSET DB2 = #Request.BaseDSN2#>
<CFSET DB3 = #Request.BaseDSN3#>
INSERT INTO DB3.....etc
I do appreciate your time- I wish they had spell-check on the community support app- this is Adobe...