文档日志查询及删除

1、查询

SELECT * FROM docdetaillog
WHERE OPERATEUSERID=(SELECT ID FROM HrmResource WHERE lastName='XX');
SELECT * FROM docreadtag
WHERE USERID =(SELECT ID FROM HrmResource WHERE lastName='XX');
SELECT * FROM 	downloadlog
WHERE USERID =(SELECT ID FROM HrmResource WHERE lastName='XX');

2、删除

DELETE FROM  docdetaillog
WHERE OPERATEUSERID=(SELECT ID FROM HrmResource WHERE lastName='XX');
DELETE FROM  docreadtag
WHERE USERID =(SELECT ID FROM HrmResource WHERE lastName='XX');
DELETE FROM  downloadlog
WHERE USERID =(SELECT ID FROM HrmResource WHERE lastName='XX');