左边的表记为a ,右边为b
select value_description from a
where exisit (select 1 from (select distinct bank_id id from b
union
select distinct brand_id id from b
union
select distinct check_flag id from b) c
where a.value=c.id)
select value_description from a
where exisit (select 1 from (select distinct bank_id id from b
union
select distinct brand_id id from b
union
select distinct check_flag id from b) c
where a.value=c.id)
解决方案 »
- 求2个date字段,相差多少个月?
- 关于数据库的创建和连接问题
- 谁有oracle 10g OCA认证考试资料
- A question about oracle varray and nested table
- 求一条SQL语句:如何替换字段中的字符?
- Oracle中Blob字段的update问题
- exp导出的几个特殊要求,请大哥帮忙
- 在ORACLE9i中,能否在一个方案中建立“基于另外一个方案中表的内容的视图”送100分!!
- 求备份设计方案!需不需要raid,若需要,什么类型合适一些?定结贴
- 为什么用ODBC访问ORACLE8.17会出现内存访问违例?在线等待,着急啊!
- 一个查询不连续数字记录的问题
- 如何查询多段时间
select value_description from a
where exisit (select 1 from (select distinct bank_id id from b
union
select distinct brand_id id from b
union
select distinct to_number(check_flag) id from b) c
where a.value=c.id)
银行名字 品牌 对账
工商银行 全球通 50或者为null也可以不知道描述清楚没有,麻烦你看看能不能解决
a1value as '银行名字',
a2.value as '品牌’
a3.value as '对账'
from b,
a a1,
a a2,
a a3
where b.brank_id=a1.value(+)
and b.brand_id=a2.value(+)
and b.check_flag=a3.value(+)