create materialized view ZH_WRITEFILE
refresh complete on demand
start with to_date('04-05-2009 02:00:00', 'dd-mm-yyyy hh24:mi:ss') next TRUNC(SYSDATE+1)+2/24
as
(
select 'CJW_'||ID ID,'' ARCHIVESSYMBOL,'' ReduceNum,'SELECT AID from WRITECATALOG where=WRITEFILE.AJID=ID' AID,DOCNO DocumentNum,PIECENUM SerialID,TITLE OriginalTitleName,DutyMen DutyMen,DOCUMENTDATE DocumentDate,'' PieceNum,SecretLevel SecretLevel,'' SAVETERM,PAGE Pages,'' StartPage,REMARK Re,'' SaveDepartment,'' SaveMen,'' SaveDate,QZBS QZBS,QZH QZH
FROM =WRITEFILE
)
其中'SELECT AID from WRITECATALOG where WRITEFILE.AJID=ID' AID 这一段有问题,我的目的是通过WRITECATALOG表里的ID字段和WRITEFILE表里的AJID字段做关联,把WRITECATALOG表里的AID取出来。请问各位学哥学姐怎么写才对,谢了!
refresh complete on demand
start with to_date('04-05-2009 02:00:00', 'dd-mm-yyyy hh24:mi:ss') next TRUNC(SYSDATE+1)+2/24
as
(
select 'CJW_'||ID ID,'' ARCHIVESSYMBOL,'' ReduceNum,'SELECT AID from WRITECATALOG where=WRITEFILE.AJID=ID' AID,DOCNO DocumentNum,PIECENUM SerialID,TITLE OriginalTitleName,DutyMen DutyMen,DOCUMENTDATE DocumentDate,'' PieceNum,SecretLevel SecretLevel,'' SAVETERM,PAGE Pages,'' StartPage,REMARK Re,'' SaveDepartment,'' SaveMen,'' SaveDate,QZBS QZBS,QZH QZH
FROM =WRITEFILE
)
其中'SELECT AID from WRITECATALOG where WRITEFILE.AJID=ID' AID 这一段有问题,我的目的是通过WRITECATALOG表里的ID字段和WRITEFILE表里的AJID字段做关联,把WRITECATALOG表里的AID取出来。请问各位学哥学姐怎么写才对,谢了!
解决方案 »
- vmware server client按power on出现error
- sql列转行问题
- sql问题 请求助高手~~
- 这个SQL不用别名怎么写,有没有类似MSSql中的[]呀,高分(急)
- oracle9i要如何修改初始化(init.ora)参数的值?
- 关于oracle建立序列问题?
- 在一台服务器上能同时装Oracle9iAS的infrastructure和portal吗?机器重启后如何重起服务?急
- 如何使用Oracle9i的复杂查询语句
- 谁能快点告诉我一个问题啊!江湖救急啊!百分救急!
- oracle 口令无法输入字符什么
- 求一条oracle语句取出想要的结果
- sql语句在存储过程中实现的问题!!
FROM =WRITEFILE 你这句能确保执行出正确结果吗
这里引号应该改为括号吧!这个查询语句能查询出正确结果吗?
改为:
(SELECT AID from WRITECATALOG where WRITEFILE.AJID=ID) AID ;
射射
FROM =WRITEFILE 执行这个包啥错呢