I have the table1 below and want to make a table that shows how many friends Ent1 has in common with any other person from Ent1. Eg A (short for AAA) has friends B,C,D,E,F while B has friends A,C,E,F. They have C,E,F in common so the outcome should be AAA BBB 3
Can this be done in acces/SQL? I...