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 ...
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 ...