SELECT
a.field1,a.field2,a.business_type,a.send_type,b.business_type_name,c.send_type_name
FROM T_DATA
LEFT JOIN TDC_DOMAIN b
ON a.business_type = b.domain_value
AND b.domain_code = 'business_type'
LEFT JOIN TDC_DOMAIN c
ON a.business_type = c.domain_value
AND b.domain_code = 'send_type'
a.field1,a.field2,a.business_type,a.send_type,b.business_type_name,c.send_type_name
FROM T_DATA
LEFT JOIN TDC_DOMAIN b
ON a.business_type = b.domain_value
AND b.domain_code = 'business_type'
LEFT JOIN TDC_DOMAIN c
ON a.business_type = c.domain_value
AND b.domain_code = 'send_type'
解决方案 »
- SMON实例恢复问题!!
- oracle中用触发器如何获得一个表某字段修改前后的值(回答的马上散分)
- 在不同服务器之间使用copy能指定被copy的表到指定表空间吗?如下:
- 在pl\sql的命令窗口如何执行返回记录集的存储过程
- 多层查询的问题....
- 新手学习ORACLE存储过程
- 如何给写一个传入查询条件返回结果集的存储过程,大家帮帮忙吧.
- 放分
- Oracle9.2.0.2安装时发生GetAllOracleHomes错误自动退出,报告jvm.dll的问题
- system不能以sysdba身份登陆!!!!!!!!!!
- Oracle9i数据库连接问题??
- 請問如何把一張表的數據移到另一張表中(只需要部分即可)阿,sql怎麼寫?另一張表的創建能用複製第一張表嗎?在線等...
---------------------------------------------------------------------
SELECT
a.field1,a.field2,a.business_type,a.send_type,
b.domain_name business_type_name,c.domain_name send_type_name
FROM T_DATA a
LEFT JOIN TDC_DOMAIN b
ON a.business_type = b.domain_value
AND b.domain_code = 'business_type'
LEFT JOIN TDC_DOMAIN c
ON a.business_type = c.domain_value
AND c.domain_code = 'send_type'
from T_DATA t,TDC_DOMAIN t1,TDC_DOMAIN t2
where t.business_type=t1.domain_value
and t1.domain_code='business_type'
and t.send_type=t2.domain_value(+)
AND t2.domain_code='send_type'由于t_data表中的send_type可能为NULL
以上写法记录数差了很多,只显示send_type不为NULL的
我想让为NULL的值也显示出来,该如何改?
from T_DATA t,TDC_DOMAIN t1,TDC_DOMAIN t2
where t.business_type=t1.domain_value
and t1.domain_code='business_type'
and t.send_type=t2.domain_value(+)
AND t2.domain_code(+)='send_type'
OK,搞定,谢谢 xpony(xiezequn)
a.business_type,
a.send_type,
b.domain_name business_type_name,
c.domain_name send_type_name
from t_data a,
(
select * from dtc_domain where domain_code='business_type'
) b,
(
select * from dtc_domain where domain_code='send_type'
) c
where a.business_type=b.domain_code(+) and a.send_type=c.domain_code(+);