how to create monster.com like search results?

[Anton Margo]

Hi, I am trying to create something similar to monster.com search or for that matter any other job search engine.

I have
Skills : SkillID, SKillName - SkillID PK
Person : UID, FName - UID PK
PersonSkills : UID, SkillID - linking table no PK

Now One person can have multiple skills. So when I write a search - I will probably be writing something like

SELECT UID From Person WHERE UID=(SELECT From PersonSkills WHERE SkillID=XX OR SkillID=YY OR SkillID=ZZ) SORT BY FullName

There is a small issue with the query above is that it will not sort for the best possible match (i.e. if a person has XX, YY and ZZ skills he/she should be in the front). How can i fix this?

Thanks for all the help,
AM

[Madhi]

Hi try the following

SELECT UID From Person WHERE UID=(SELECT From PersonSkills WHERE SkillID=XX OR SkillID=YY OR SkillID=ZZ) SORT BY UID

Madhivanan