甯歌闂?shù)笌鍒嗘?/div>
鍏抽棴
甯歌闂?shù)笌鍒嗘?/p>
鍐呴儴鏁版嵁閿欒
鎺掓煡鏂規(guī)硶錛?/p>
鍦ㄥ笎濂楀簱榪愯涓嬪垪璇彞錛屽鏋滀笉鑳芥壘鍒拌褰曪紝鍒欒鏄庡綋鍓嶇櫥褰曢兘鐨勯儴闂ㄦ垨鍏徃娌℃湁錛屽叾涓?ey00313='1001',1001涓虹櫥褰曞悕錛屾浛鎹㈣繖涓嵆鍙€?/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'
