QoQ OR Joins + Unions using junction table?

2 replies
218 views
Translate

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.

This topic is closed to new replies. Start a new post to keep the conversation going.

BKBK

Community Expert

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).

Translate

S

seasonedwebAuthor

Inspiring

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:

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...

Translate

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.