Hello all
i have 2 table as image above, what i am looking for is:
JobApplic table contain:
ApplicNum, JobNum, UID "this is the employer", Jobtitle, AplicUID " this is job seeker"
CVs table contain:
CVNum, UID (here in this table is the job seeker) , Birthday , etc....
The statement it something like that but i am not so professional to write in the correct way:
" select from [JobApplic] ApplicNum,JobNum, UID, Jobtitle, AplicUID where UID into table JobApplic
= session["UsrNme"], and from table [CVs] UID,CVNum, Birthday, Gender, ... Where UID into table CVs = ApplicUID "
The mean point from this code is when employer enter to his account he will b ...
Go to the complete details ...