|
|
|
 |
信息统计 |
|
 |
|
|
|
|
|
|
|
黄山房管局SQL语句执行错误(2012-1-28 14:37:50) 返回 重试错误源: Microsoft OLE DB Provider for Oracle错误描述: ORA-00918: column ambiguously defined
错误语句如下: select * from (select id,project 项目名称,permitsaleno 预售证号,to_char(commitdatetime,'yyyy-mm-dd') 批准时间 from tt.virtualproperty v,tt.rightcert r,tt.rightcertroom rcr where v.id=r.activeid and r.isvalid=-1 and r.certid=rcr.certid and exists (select 1 from roomright where bldroomid=rcr.bldroomid and nextrightid is null and righttypeid in (1,2,3)) and v.commitdatetime is not null group by id,project,permitsaleno,to_char(commitdatetime,'yyyy-mm-dd')) where rownum<10 order by id desc
| | |