Select
m.org_cid,
m.dt,
Max(decode(m.desc_id,3752, m.cur_num,Null))lab_dis_far_num,
Max(decode(m.desc_id,3753, m.cur_num,Null))dir_lab_num,
Max(decode(n.desc_id,'3772', n.cur_val,Null))mig_work_sta,
Max(decode(n.desc_id,'3773', n.cur_val,Null))gro_car_summ
From dc_data_num m ,dc_data_str n
Where m.org_cid=n.org_cid(+)
And m.dt=n.dt(+)
And m.prop=3
And m.desc_id In(3752,3753)
And n.desc_id In('3773','3772')
Group By m.org_cid,m.dt
m.org_cid,
m.dt,
Max(decode(m.desc_id,3752, m.cur_num,Null))lab_dis_far_num,
Max(decode(m.desc_id,3753, m.cur_num,Null))dir_lab_num,
Max(decode(n.desc_id,'3772', n.cur_val,Null))mig_work_sta,
Max(decode(n.desc_id,'3773', n.cur_val,Null))gro_car_summ
From dc_data_num m ,dc_data_str n
Where m.org_cid=n.org_cid(+)
And m.dt=n.dt(+)
And m.prop=3
And m.desc_id In(3752,3753)
And n.desc_id In('3773','3772')
Group By m.org_cid,m.dt
解决方案 »
- Oracle使用record不知道表结构问题
- 请问能否在pl\sql中执行exp备份命令?
- 关于 oracle tablespace point-in-time recovery(TSPITR)
- oracle备份????
- 使用SQL关键字做表名如何写SQL语句?
- 这样的imp语句应该怎么写????
- 怎样改变已经设为外键的字段的类型呀?
- 怎么把数据库里时间字段的日期部分值取出来啊
- 请问为何在sql*plus下用create table命令建表后在OEM或OMS看不到,我用了commit提交过了,而在sql*plus worksheet中就可以?
- grant connect,resource to user 究竟包括那些权限,谢谢!20分
- oracle函数使用
- ttisql 是什么东东
m.org_cid,
m.dt,
Max(decode(m.desc_id,3752, m.cur_num,Null))lab_dis_far_num,
Max(decode(m.desc_id,3753, m.cur_num,Null))dir_lab_num,
Max(decode(n.desc_id,'3772', n.cur_val,Null))mig_work_sta,
Max(decode(n.desc_id,'3773', n.cur_val,Null))gro_car_summ
From dc_data_num m ,dc_data_str n
Where m.org_cid=n.org_cid(+)
And m.dt=n.dt(+)
And m.prop=3
And m.desc_id In(3752,3753)
And n.desc_id(+) In('3773','3772')
Group By m.org_cid,m.dt
否则相当于没使用外连接