Joining two tables to a third

[Violent_Democracy]

Hi all,

I have three tables

Extract

Position

System Group

Object name

Employee

User ID

Name

Position

System Group

GroupSharedUser

UniqueName

User ID

Currently I am using the following formula

Extract:
LOAD
[Position],
[System Group],
[Object name]
FROM [lib://
(ooxml, embedded labels, table is Extract);

Join (Extract)

Employee:
LOAD
[User ID],
[Name],
[Position],
[System Group]
FROM [lib://
(ooxml, embedded labels, table is Employee);

GroupSharedUser:
LOAD
[UniqueName],
[User ID]
FROM [lib://
(ooxml, embedded labels, table is GroupSharedUser);

This has the following output

User ID	Name	Position	System Group	UniqueName
GOODDAD	DANIEL GOODDAY	5001005	AuditCreator	AuditCreator
GOODDAD	DANIEL GOODDAY	5001005	AuditCreator	GeneralGroup
GOODDAD	DANIEL GOODDAY	5001005	AuditCreator	ReadOnly
GOODDAD	DANIEL GOODDAY	5001005	AuditCreator	PurchasingUser
GOODDAD	DANIEL GOODDAY	5001005	GeneralGroup	AuditCreator
GOODDAD	DANIEL GOODDAY	5001005	GeneralGroup	GeneralGroup
GOODDAD	DANIEL GOODDAY	5001005	GeneralGroup	ReadOnly
GOODDAD	DANIEL GOODDAY	5001005	GeneralGroup	PurchasingUser
GOODDAD	DANIEL GOODDAY	5001005	ReadOnly	AuditCreator
GOODDAD	DANIEL GOODDAY	5001005	ReadOnly	GeneralGroup
GOODDAD	DANIEL GOODDAY	5001005	ReadOnly	ReadOnly
GOODDAD	DANIEL GOODDAY	5001005	ReadOnly	PurchasingUser

I want a new column at the end of the table that shows (in a count form of 1,2, 3 etc) where UniqueName has more access than System Group. So using the above example I would have a new column that showed a 1 (Because PurchasingUser exists in UniqueName but not System Group).

Also, is this the most efficient method of joining the tables together to produce the output table I want?

Thanks