本文提供了一个SQL查询语句示例，用于从数据库中筛选特定条件的工作项记录。通过连接多个表并使用where子句，精确地获取了指定项目ID和业务单元ID下的有效工作项。
select w.IWORKITEMID as iworkitemid,
w.SWORKITEMNO as sworkitemno,
w.IBUID as ibuid,
w.SWORKITEMDESC as sworkitemdesc
from T_TLC_WORKITEM w
where w.IBUID = '241'
and w.ivalid = 0
and w.iworkitemid <= 0
and exists (select 0
from t_tlc_project_wbs_ref wref,
t_tlc_wbs_template wbs
where wref.itask_id = wbs.itaskid
and wref.iproject_id = '4797'
and wbs.iwbstypeid = w.iworkitmetypeid
and wbs.istatus = 0
w.SWORKITEMNO as sworkitemno,
w.IBUID as ibuid,
w.SWORKITEMDESC as sworkitemdesc
from T_TLC_WORKITEM w
where w.IBUID = '241'
and w.ivalid = 0
and w.iworkitemid <= 0
and exists (select 0
from t_tlc_project_wbs_ref wref,
t_tlc_wbs_template wbs
where wref.itask_id = wbs.itaskid
and wref.iproject_id = '4797'
and wbs.iwbstypeid = w.iworkitmetypeid
and wbs.istatus = 0
扫一扫
9万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
