Hi,

I have two tables:
persons:
ID,name,skillLevelID
1,John,4
2,George,4
3,Caroline,2
4,Harold,3
5,Arnold,2


SkillLevel:
ID,Name
1,The Best
2,Good
3,Sufficent
4,Reasonable
5,Not that good
6,Bad
7,Awful

The output should be
Skilllevels:
Person,level
John,reasonable
George,reasonable
Caroline,Good
Arnold,Good

Basically I want just the duplicate records individually

I know this should be possible, but at some point I had 8 Inner Joins
and 4 subqueries, so I must be doing something wrong

Thanks in advance