查询某人----所有流程待办事项

select distinct(a.requestid),b.requestname

from workflow_currentoperator a,workflow_requestbase b

where b.status!='提醒' and

isremark in (0) and

viewtype=0 and

a.requestid = b.requestid and

userid = 388

select distinct(a.requestid),b.requestname

from workflow_currentoperator a,

workflow_requestbase b

where isremark in (0,1,8,9) and

a.requestid = b.requestid and

a.userid = 388