當然可以的。
只是要注意邏輯的清晰表達,如:
(a and b) or (c and d)
只是要注意邏輯的清晰表達,如:
(a and b) or (c and d)
解决方案 »
- sql 语句怎么写?合并花圈的两条
- [ins-20802]orcal net configuration assistant 失败
- oracle 10g 插入字符(非中文字符)出现乱码
- 问个存储过程
- oracle性能问题?
- ORACLE链接中SERVICE_NAME、SID问题
- oci开发问题
- 高分求救!用PL/SQL怎么监测其它程序对Oracle9i数据库的访问,类似于SQLServer的事件查看器的功能.?
- [求助]怎样远程连接oracle数据库 ,谢谢!
- 作业提交时报错!
- 急救!关于OLEDB连ORCLE读IMAGE数据格式问题!
- asp用ado联不上oracle?(使用OraOLEDB)
select ziliao_list.* from ziliao_list,ziliao_type where (ziliao_list.[名称] like '%a%' or ziliao_list.[移交人] like '%a%' or ziliao_list.[项目] like '%a%' or ziliao_list.[归档日期] like '%a%' or ziliao_list.[区域] like '%a%' or ziliao_list.[接收人] like '%a%' or ziliao_list.[国家] like '%a%' or ziliao_list.[存放地址] like '%a%' or ziliao_list.[油田] like '%a%' or ziliao_list.[备注] like '%a%' or ziliao_list.[区块] like '%a%' or ziliao_list.[比例尺] like '%a%' or ziliao_list.[原档案编号] like '%a%' or ziliao_list.[测量深度] like '%a%' or ziliao_list.[公司] like '%a%' or ziliao_list.[测井类型] like '%a%' or ziliao_list.[内容简介] like '%a%' or ziliao_list.[测井日期] like '%a%' or ziliao_list.[关键词] like '%a%' or ziliao_list.[测线] like '%a%' or ziliao_list.[索引号] like '%a%' or ziliao_list.[桩号] like '%a%' or ziliao_list.[类别] like '%a%' or ziliao_list.[ZONE] like '%a%' or ziliao_list.[报告份数] like '%a%' or ziliao_list.[LINE NO] like '%a%' or ziliao_list.[图件份数] like '%a%' or ziliao_list.[CDP STAKE NO] like '%a%' or ziliao_list.[附表份数] like '%a%' or ziliao_list.[CDP RANGE] like '%a%' or ziliao_list.[光盘份数] like '%a%' or ziliao_list.[剖面次数] like '%a%' or ziliao_list.[资料来源] like '%a%' or ziliao_list.[剖面张数] like '%a%' or ziliao_list.[资料年度] like '%a%' or ziliao_list.[胶片生产年度] like '%a%' or ziliao_list.[资料编写人] like '%a%' or ziliao_list.[胶片生产单位] like '%a%' or ziliao_list.[保管期限] like '%a%' or ziliao_list.[胶片处理时间] like '%a%' or ziliao_list.[保管密级] like '%a%' or ziliao_list.[胶片处理机型] like '%a%' or ziliao_list.[移交日期] like '%a%') and (ziliao_list.id=ziliao_type.id) order by ziliao_type.id