当前位置: 代码迷 >> Oracle管理 >> 报ORA-00918:column ambiguously defined异常
  详细解决方案

报ORA-00918:column ambiguously defined异常

热度:77   发布时间:2016-04-24 04:58:04.0
报ORA-00918:column ambiguously defined错误
select *
  from (select a.*,rownum rn 
          from (select t.vrid,
                       t.province,
                       t.customer,
                       t.cartypecode,
                       t.engine,
                       t.carnumber,
                       t.gboscode,
                       t.v3gvideocode,
                       
                       t.enginenumber,
                       t.vincode,
                       
                       t.platenumber,
                       
                       t.sensorcharcoefficient,
                       t.factk,
                       
                       t.theoryk,
                       t.tireradius,
                       t.backbridgespeed,
                       t.softmathk,
                       t.kissueddate,
                       t.installdate,
                       t.equmentchange,
                       t.installplace,
                       t.getinfodate,
  相关解决方案