Page 1 of 1

SQL Query help

Posted: Sat Mar 21, 2009 12:06 pm
by nishmgopal
Hey guys, I just wanted some advise on what my sql query would like for the following:

I have two tables: Job_Table and Person_Table

Job_Table has:

j_name, skill, skill_weight

Person_table has:

p_name, skill, skill_score

I want to write a query where The skills in jobs are compared with the skills in person, and i want to display the person name only if all the skills are present in both... does this make sense?

thanks

Re: SQL Query help

Posted: Sat Mar 21, 2009 11:55 pm
by tech603
You could do something like this:

select p_name from Person_Table where skill = Job_Table.skill

This would return the names of the people when the skills match in both tables.

hope that helps

Matthew Vass
QA Anylist
mvass@hostmysite.com
http://www.hostmysite.com?utm_source=bb