How to write the Query ??
How to write the query to check the user applied for the job or not??
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Khargesh RajputPosted Mar 13, 2015, 9:54 AM
Select userid from jobdetail where userid='youruserid' and jobid='jobwhichyouwantcheck'
Now if query return any record means user have appiled for job else not appplied