Need help to build the sql logic
I am working on a requirement for position incumbent. Here my code will get each positon with vacant positon details. And for each position one record I am getting. My requirement is, I want to print the each position multiple time as per the vacant positions avaiable.
Eg; Position ABC having 3 vacant position and the output coming in one line as per the existing code. I want to print the Position records 3 times instad of once based on the vacant position.
I have tried many ways but failing to build this logic.
Please review the attached sql and let me know the logic.