sql 迈安

SELECT b.* FROM dbo.[耕地肥料_01土壤肥料机构建设基本情况]as b ,bs_org where
--县
(b.任务id in(
(select bs_task.id
--,bs_org.name_ as organizationname,bs_user.id as bs_userid,bs_user.casid_
from bs_task
inner join bs_org on bs_task.taskorg_=bs_org.id
inner join bs_user on bs_user.dljc_organization=bs_org.id
where casid_='${casid_}') ) or
--市
b.任务id in
(select bs_task.id from bs_task inner join
(SELECT a1.casid_ as father_casid_,bs_org.id FROM dbo.[bs_org] inner join (select id ,dljc_organization,casid_ from bs_user where casid_='${casid_}') a1 on bs_org.dljc_organization=a1.dljc_organization) a on a.id=bs_task.taskorg_) or
--省
b.任务id in
(select bs_task.id from bs_task where bs_task.taskorg_ in(
select bs_org.id from bs_org where bs_org.dljc_organization in(
select bs_org.id
--,bs_org.name_
from bs_user inner join bs_org on bs_org.dljc_organization=bs_user.dljc_organization and casid_='${casid_}'
)))
or '${casid_}'='ADMIN' or bs_org.level_='省级') and b.年度='${year}'

转载于:https://www.cnblogs.com/yijiaming/p/8430403.html