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
SQL Query help
Moderator: General Moderators
Re: SQL Query help
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
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