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'
解决方案 »
- 为什么like里面用[]和^不起作用
- 部署产品时,连接ORACLE数据报如下错误,速度求解……
- PL/SQL 同义词 混乱.............
- 变异表问题,怎么锁定包中的变量
- 请教一个oracle备份的问题
- 救命啊,为何其他机器上运行不报错,放到服务器上就报"ORA-01861: 文字与格式字符串不匹配"
- 执行效率问题,有兴趣的进来!
- 高分求 《复合试的查询》,请帮忙!
- 关于机构配置中的一人多岗的问题
- 关于sequence的问题!!!!!
- 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(+);