Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
SQL Query to get Candidate details with respect to particular Job requisition — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL Query to get Candidate details with respect to particular Job requisition

Accepted answer
480
Views
3
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!