nishmgopal Posted March 21, 2009 Share Posted March 21, 2009 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 Link to comment https://forums.phpfreaks.com/topic/150481-sql-query-help/ Share on other sites More sharing options...
irkevin Posted March 21, 2009 Share Posted March 21, 2009 $query = "SELECT job_table.skill,person_table.skill,person_table.p_name FROM job_table,person_table WHERE job_table.skill = person_table.skill"; try this.. i just wrote this quickly.. Link to comment https://forums.phpfreaks.com/topic/150481-sql-query-help/#findComment-790366 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.