SQL Query help
Posted: Sat Mar 21, 2009 12:06 pm
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
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