Puzzle 41 Associate IDs

[maximilian22x]

AdvancedSQLPuzzles/Advanced SQL Puzzles/Advanced SQL Puzzles Solutions.sql

Line 1950 in 2306e23

Answer to Puzzle #41

What is the column "grouping" for? Do not understand that column.
Why this code is not enough?

SELECT Associate1 
FROM #Associates 
Union 
SELECT Associate2 
FROM #Associates 

[smpetersgithub]

The puzzle needs to be better written.

Here is a better description.

_The following table shows two hierarchical structures.

1. The first is the association between Anne, Betty, Charles, Dan and Emma.
2. The second is the association between Francis, George, and Harriet.

Write an SQL statement that creates a grouping number for each hierarchical association and display the member in the associations._

[smpetersgithub]

Closing