|
6#
发表于 2012-12-11 20:43
来自手机
|
只看该作者
lz, 测试一下如下的代码, 目前我给的代码是已经基于你贴的2表数据, 如果要加其他条件自己改一改即可, 如果结果不对, 把原因详细说明!
代码如下:
select a.patient,
min(a.diagnosis_no) keep(dense_rank first order by decode(b.diagnosis_class, null, null, a.diagnosis_no) nulls last) diagnosis_no,
min(b.diagnosis_class) keep(dense_rank first order by decode(b.diagnosis_class, null, null, a.diagnosis_no) nulls last) diagnosis_class
from diagnostic_category a,
diagnosis_dict b
where a.diagonosis_code = b.diagonosis_code(+)
group by a.patient;
|
|