It does look like it would work if I added the "type" from the group table to the group_member table. But otherwise the PARITION BY LIST does not support referencing a parent table.
Replace “parent table” with “some random table only related to the table in question by a foreign key” and it probably will make more sense.
David J.
