select a.* from t_3ioj4GeZQU a where status=‘A’ AND batch_Id in(SELECTbatch_id from batch_log bLEFT JOIN office o ON b.dept_id = o.IDLEFT JOIN area a on o.AREA_ID = a.IDWHERE target = ‘21’ AND (