---> select opr.ownerId, opr.fsltablecode, opr.operatorId, opr.fsl_choId from tbl_OPR_ClientOperators opr left outer join tbl_OPR_ClientOperators p on opr.oprparentco = p.operatorId where opr.operatorId = 1415834 ---> update tbl_OPR_ClientOperators set fsl_choIdStatus = 'M', fsl_choIdBy = 783806, fsl_choIdDate = , oprcompanytype = '0', independentYN = 1 where operatorId = #_choIds#