Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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).
Copy link to clipboard
Copied
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
SELECT ...etc
FROM DB2?
I do appreciate your time- I wish they had spell-check on the community support app- this is Adobe...