摘要：SELECT distinct B.AGR_NAME,B.UNAME,right(B.UNAME,6) as xuhao,A.TCODEFROM AGR_TCODES AS A INNER JOIN AGR_USERS AS BON A.AGR_NAME = B.AGR_NAME INNER JOIN V_USERNAME AS CON B.UNAME = C.BNAMEwhere B.UNAME like '%***%'ORDER BY B.UNAME,A.TCODE 阅读全文

摘要：表名：USR02解锁语句:update USR02 set uflag=0 where bname='username' and mandt=*** 阅读全文