Hi,

Thanks for the repsonse

Unfortunately, this is just a simple join finding the fields together.
This way the textual skillevel for each individual is listed
What I need is that only the duplicates are shown individually

Serge

On Wed, Jul 30, 2008 at 1:15 PM, Lester Caine <lester@...> wrote:

> serge.fonville wrote:
> > 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
>
> Simple
>
> SELECT a.NAME, b.NAME
> FROM PERSONS a
> JOIN SKILLLEVEL b ON a.SKILLLEVELID = b.ID
>
> --
> Lester Caine - G8HFL
> -----------------------------
> Contact - http://lsces.co.uk/lsces/wiki/?page=contact
> L.S.Caine Electronic Services - http://lsces.co.uk
> EnquirySolve - http://enquirysolve.com/
> Model Engineers Digital Workshop - http://medw.co.uk//
> Firebird - http://www.firebirdsql.org/index.php
>
>
>


[Non-text portions of this message have been removed]