常见问题与分?/div>
关闭
常见问题与分?/p>
内部数据错误
排查Ҏ(gu)Q?/p>
在帐套库q行下列语句Q如果不能找到记录,则说明当前登录都的部门或公司没有Q其?ey00313='1001',1001为登录名Q替换这个即可?/p>
SELECT userId=pj00401, userName=pj00402, userState=pj00412, pj00421, pj00301, pj00302, pj02501, pj02506, ey00307=ey00307 + ey00311,
thisTime=Convert(varchar(19), GetDate(), 21), ey00312 FROM sdpj004
INNER JOIN sdey003 ON pj00421=ey00301
INNER JOIN sdpj003 ON pj00301=pj00417
INNER JOIN sdpj025 ON pj00311=pj02501
WHERE ey00313='1001'