select app.app_NO, app.TRANSFER_ORGAN,app.STATE, t.BACK_DATE,t.FEEDBACK_DATE,t.RECEIVE_DATE,t.RETURN_DATE,Db_num,daly_num
from App_register app
left join (
select a.app_no, a.BACK_DATE,a.FEEDBACK_DATE,a.RECEIVE_DATE,a.RETURN_DATE,Db_num,daly_num
from TURN_INFO a
left join (
select turn_id,count(SUPERVISE_DELAY_INFO.DELAY_REASON)as daly_num,count(SUPERVISE_DELAY_INFO.SUPERVISE_OPINION)as Db_num
from DB2INST2.SUPERVISE_DELAY_INFO
group by turn_id
) b
on a.ID=b.turn_id
) t
on app.APP_NO= t.APP_NO
where app.APP_NO_ZJ='2c909e0f57a203220157a20508aa0001'