SELECT *
FROM v_company v
WHERE v.company_id IN
(SELECT b.company_id
FROM t_company_business b
WHERE b.business_id IN
(SELECT d.business_id
FROM t_ins_dic_central_business d
WHERE d.business_type_code = 'ypzx'))
and v.company_id IN(
SELECT m.company_id FROM mv_role_act_document_business m
WHERE m.user_code='sinopec\xiaoyu.li')
FROM v_company v
WHERE v.company_id IN
(SELECT b.company_id
FROM t_company_business b
WHERE b.business_id IN
(SELECT d.business_id
FROM t_ins_dic_central_business d
WHERE d.business_type_code = 'ypzx'))
and v.company_id IN(
SELECT m.company_id FROM mv_role_act_document_business m
WHERE m.user_code='sinopec\xiaoyu.li')
解决方案 »
- SQL拼接
- 请大神们予以指导下这个导入导出的sh 如何优化 速度更快
- XMLP 做EBS报表的时候报了一个莫名奇妙的错
- oracle,data mining,data miner连接时报错:Specified schema is not configured for use with Oracle Data Mining
- 两表关联查询
- 视图作表名的问题(我建立视图后查询,和把视图作为动态表名来查询,结果为什么不一样呢)
- 求教如何快速删除大量数据,大家都来看看,也许你也遇到过同样的问题。
- 现在mysql数据库有数据向oracle中导入
- 导入不同的表空间
- 我又来JJYY了,求差集的SQL语句
- 请教一个日期转换的问题
- oracle 11 oracle.exe 特别占 cpu ,远程无法连接 两个问题,谢谢。
from v_company a,t_company_business b,t_ins_dic_central_business c,mv_role_act_document_business d
where a.company_id=b.company_id and b.business_id=c.b.business_id and c.business_type_code = 'ypzx'
and a.company_id=d.company_id and d.user_code='sinopec\xiaoyu.li'
SELECT v.*
FROM v_company v, t_company_business b, mv_role_act_document_business m
where (v.company_id = b.company_id and exists
(SELECT 1
FROM t_ins_dic_central_business d
WHERE d.business_type_code = 'ypzx'
and d.business_id = b.business_id))
or (v.company_id = m.company_id and exists
(SELECT 1
FROM mv_role_act_document_business m
WHERE m.user_code = 'sinopec\xiaoyu.li'))
select *
from v
inner join b on v.id = b.id
inner join c on b.id = c.id
inner join d on c.id = d.id and d.business_type_code = 'ypzx'
inner join m on v.id = m.id and m.user_code='sinopec\xiaoyu.li'
SELECT *
FROM v_company v
WHERE v.company_id IN
(SELECT b.company_id
FROM t_company_business b,t_ins_dic_central_business d where d.business_type_code = 'ypzx' and b.business_id=d.business_id)
and v.company_id IN(
SELECT m.company_id FROM mv_role_act_document_business m
WHERE m.user_code='sinopec\xiaoyu.li')
from v_company a,t_company_business b,t_ins_dic_central_business c,mv_role_act_document_business d
where a.company_id=b.company_id and b.business_id=c.b.business_id and c.business_type_code = 'ypzx'
and a.company_id=d.company_id and d.user_code='sinopec\xiaoyu.li'
SELECT *
FROM v_company v
WHERE v.company_id IN
(SELECT b.company_id
FROM t_company_business b,t_ins_dic_central_business d where d.business_type_code = 'ypzx' and b.business_id=d.business_id)
and v.company_id IN(
SELECT m.company_id FROM mv_role_act_document_business m
WHERE m.user_code='sinopec\xiaoyu.li'
SELECT * FROM v_company v
WHERE exists(
SELECT 1 FROM t_company_business b
WHERE v.company_id=b.company_id
and exists(
SELECT 1 FROM t_ins_dic_central_business d
WHERE d.business_type_code = 'ypzx'
and b.business_id=d.business_id))
and exists(
SELECT 1 FROM mv_role_act_document_business m
WHERE m.user_code='sinopec\xiaoyu.li'
and v.company_id=m.company_id)
select distinct a.*
from v_company a,t_company_business b,t_ins_dic_central_business c,mv_role_act_document_business d
where a.company_id=b.company_id and b.business_id=c.b.business_id and c.business_type_code = 'ypzx'
and a.company_id=d.company_id and d.user_code='sinopec\xiaoyu.li'