SQL Query to get Candidate details with respect to particular Job requisition
Summary:
SQL Query to get Candidate details with respect to particular Job requisition
Content (required):
Hi Experts,
We have a requirement in report in Recruiting module. We have to capture the Candidate number, name with respect to particular job requisition. I could able to fetch candidate details and Requisition details separately. But to get Candidate details with respect to particular requisition there has to be some joins needs to be used. But I am not able to find anything like that. Can someone help me with the sample SQL query which has the below columns:
1. Requisition number
2. Requisition title
3. Candidate number
Tagged:
0