SELECT DISTINCT c.company_id,
FROM company c,
authority a,
authority_lob alob
WHERE c.company_id = a.company_id
AND a.authority_id = alob.authority_id
AND a.authority_status_id = 14
AND alob.lob_id IN (1, 4, 5, 44, 45)
ORDER BY c.company_nm
FROM company c,
authority a,
authority_lob alob
WHERE c.company_id = a.company_id
AND a.authority_id = alob.authority_id
AND a.authority_status_id = 14
AND alob.lob_id IN (1, 4, 5, 44, 45)
ORDER BY c.company_nm
解决方案 »
- 通过浏览器怎么访问Oracle服务呢!!?
- [求助]关于ORACLE INSTALLCLIENT客户端 与应用程序数据库连接问题!
- 如何让blob字段存储非十六进制的字符
- 请教各位大虾怎么从java里面传入记录到Oracle的存储过程中?谢谢!
- Oracle双机热备时出现的问题:Ora-01033----解决当即给分!!!大虾们辛苦了
- 高手请指教,我用ASP连不上ORACLE数据库!!!??
- 问一个很菜的问题 我怎么在一个指定的数据库里操作SQL语句???
- 安装Oracle8.1.7时出错,帮忙看看!
- lob型字段的读取问题
- oracl问题,大神求解决!
- sql 中如何选择出带有''号的字符串
- 以Orcle为后台数据库,以下SQL语句出现了错误:
想返回唯一的company_id
可以考虑group by