I'm a beginner. 4 tables and result required is given below . I'm able to achieve the result partially with this query. (getting only uat date , not all 3) Please help to achieve entire result ..
Query used :
select r.request_number,r.description, r.creation_date, u.parameter29 as proposed_deployment_date, wft.approval_date as uat_date, v.parameter14 as actual_deploy_date, r.closed date
from table2 u,table2 v , table1 r , table3 wft
where u.batch_number=1 and v.batch_number=3 and wft.step_id=41075 and r.request_number=u.request_number and r.request_number=v.request_number and wft.request_number = r.request_number order by r.request number;