delete FROM C_SPP_TSG_ERROR_MSG ste WHERE ste.spptsgorderstatusid IN ( DELETE tos.spptsgorderstatusid FROM C_SPP_TSG_ORDER_STATUS tos WHERE tos.spptsgordernotifyid IN ( DELETE ton.spptsgordernotifyid FROM C_SPP_TSG_ORDER_NOTIFY ton WHERE ton.servicerequestid = InServiceRequestID)) ;

Can i write a query like this?