MySQL Table Joins ....

wxdqz

New Member
Hello,
I Have a peculiar problem with mysql table joins.
Can anybody give me a solution for this.

My Table Structure:

ApplicantTab:

ApplicantCode ApplicantName
1000 Danny
1001 Guru

ApplicantSkillTab:

ApplicantCode SkillCode
1000 1
1000 2
1000 3
1001 1


I want to find a Applicant with both the Skills 1,2 , how do i write a query to do this.

$query = "find a person with skills 1,2";

i,e my expeted result is

ApplicantCode
1000

can somebody tell me what $query should be in the above problem.

thanks,
Danny ...
 
Back
Top