野云

表名：USR02解锁语句:update USR02 set uflag=0 where bname='username' and mandt=***  <br />

<br />SELECT distinct B.AGR_NAME,B.UNAME,right(B.UNAME,6) as xuhao,A.TCODE<br /> <br />FROM AGR_TCODES AS A INNER JOIN AGR_USERS AS B<br /> ON A.AGR_NAME = B.AGR_NAME INNER JOIN V_USERNAME AS C<br /> ON B.UNAME = C.BNAME<br /><br />where B.UNAME like '%***