两个SQL查询从workflow_currentoperator和workflow_requestbase表中选取不处于提醒状态，且isremarkin满足特定条件（第一个查询为0，第二个查询为0,1,8,9）的requestid和对应的requestname，其中userid等于388。
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
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
