当前位置: 代码迷 >> Oracle管理 >> 求给位大侠指点:ORA-00918: column ambiguously defined
  详细解决方案

求给位大侠指点:ORA-00918: column ambiguously defined

热度:58   发布时间:2016-04-24 04:48:12.0
求给位大侠指导:ORA-00918: column ambiguously defined

问题如下:

同样一段sql在DB101和DB_test这两个数据库(表结构一样,只是版本有不同,
DB101--oracle10.2.0.1.0,DB_test--oracle10.2.0.5.0)中执行,
DB101可以执行,没问题,DB_test报ORA-00918: column ambiguously defined,
表produce_info_mx,sample_manager_mx都含此字段sample_serial_number ,
两个数据库应该都报column ambiguously defined这个错误,怎么一个可以执行,另一个又不可以
sql如下:
select produce_info_mx.*,
                       produce_info.produce_name,
                       produce_info.produce_type,
                       item_info_mx.item_mx_name,
                       item_info_mx.item_mx_code
                  from produce_info_mx
                 inner join produce_info on produce_info_mx.produce_id =
                                            produce_info.produce_id
                 inner join item_info_mx on item_info_mx.item_mx_id =
                                            produce_info.item_id
                 inner join sample_manager_mx on sample_manager_mx.sample_mx_id =
                                                 produce_info_mx.produce_sample_id
                                             and produce_info_mx.produce_fact_lib_num <
                                                 produce_info_mx.produce_library_number
                                             and produce_info.PRODUCE_LIB_FLAG =
                                                 'DNA小片段'
                                             and (sample_manager_mx.CLONE_FLAG is null or
  相关解决方案