ora-00907: 缺失右括号

[mlc_ren]

在ｐｌ／ｓｑｌ里执行　　报此错
select TEMQ_1f040dd124f08b2ce1.GW GW,
TEMQ_1f040dd124f08b2cb2.GZRQ GZRQ,
TEMQ_1f040dd124f08b2bd8.DH DH,
TEMQ_1f040dd124f08b2bd8.XKHSM XKHSM,
TEMQ_1f040dd124f08b2c83.KHZS KHZS,
TEMQ_1f040dd124f08b2c83.KHZS - TEMQ_1f040dd124f08b2bd8.XKHSM LKHZS,
TEMQ_1f040dd124f08b2cb2.LDZS LDZS,
TEMQ_1f040dd124f08b2cb2.QDZS QDZS,
TEMQ_1f040dd124f08b2cb2.QFZS QFZS,
TEMQ_1f040dd124f08b2d20.QYTS QYTS,
TEMQ_1f040dd124f08b2d20.MJ MJ,
TEMQ_1f040dd124f08b2d20.JE JE,
TEMQ_1f040dd124f08b2d20.YSJE YSJE,
TEMQ_1f040dd124f08b2d20.QKJE QKJE,
sum(TEMQ_1f040dd124f08b2cb2.LFZS) LFZS
from TEMQ_1f040dd124f08b2cb2,
TEMQ_1f040dd124f08b2bd8,
TEMQ_1f040dd124f08b2c83,
TEMQ_1f040dd124f08b2d20,
TEMQ_1f040dd124f08b2ce1
where TEMQ_1f040dd124f08b2cb2.GZRQ = TEMQ_1f040dd124f08b2bd8.DJRQ
and TEMQ_1f040dd124f08b2cb2.GZRQ = TEMQ_1f040dd124f08b2c83.GZRQ
and TEMQ_1f040dd124f08b2cb2.GZRQ = TEMQ_1f040dd124f08b2d20.QYRQ
and TEMQ_1f040dd124f08b2cb2.PK_PSNDOC =
TEMQ_1f040dd124f08b2ce1.PK_PSNDOC
and ((TEMQ_1f040dd124f08b2ce1.PK_CORP = '1008') and
(TEMQ_1f040dd124f08b2bd8.PK_PSNDOC = '0001G510000000001X90') and
(TEMQ_1f040dd124f08b2c83.PK_PSNDOC = '0001G510000000001X90') and
(TEMQ_1f040dd124f08b2cb2.PK_PSNDOC = '0001G510000000001X90') and
(TEMQ_1f040dd124f08b2d20.PK_PSNDOC = '0001G510000000001X90') and
(TEMQ_1f040dd124f08b2ce1.PK_PSNDOC = '0001G510000000001X90') and
(TEMQ_1f040dd124f08b2bd8.PK_PROJECT = '0001G510000000000E8S') and
(TEMQ_1f040dd124f08b2c83.PK_PROJECT = '0001G510000000000E8S') and
(TEMQ_1f040dd124f08b2cb2.PK_PROJECT = '0001G510000000000E8S') and
(TEMQ_1f040dd124f08b2d20.PK_PROJECT = '0001G510000000000E8S') and
(TEMQ_1f040dd124f08b2ce1.PK_PROJECT = '0001G510000000000E8S') and
(TEMQ_1f040dd124f08b2cb2.GZRQ >= 'select trunc(next_day(to_date('
2009 - 10 - 30 ', ' yyyy - mm - dd '), 1) - 6) from dual') and
(TEMQ_1f040dd124f08b2cb2.GZRQ <= 'select trunc(next_day(to_date('
2009 - 10 - 30 ', ' yyyy - mm - dd '), 1) ) from dual'))
group by TEMQ_1f040dd124f08b2ce1.GW,
TEMQ_1f040dd124f08b2cb2.GZRQ,
TEMQ_1f040dd124f08b2bd8.DH,
TEMQ_1f040dd124f08b2bd8.XKHSM,
TEMQ_1f040dd124f08b2c83.KHZS,
TEMQ_1f040dd124f08b2c83.KHZS - TEMQ_1f040dd124f08b2bd8.XKHSM,
TEMQ_1f040dd124f08b2cb2.LDZS,
TEMQ_1f040dd124f08b2cb2.QDZS,
TEMQ_1f040dd124f08b2cb2.QFZS,
TEMQ_1f040dd124f08b2d20.QYTS,
TEMQ_1f040dd124f08b2d20.MJ,
TEMQ_1f040dd124f08b2d20.JE,
TEMQ_1f040dd124f08b2d20.YSJE,
TEMQ_1f040dd124f08b2d20.QKJE
请赐教

[wwwtyb]

(TEMQ_1f040dd124f08b2cb2.GZRQ >= 'select trunc(next_day(to_date('
2009 - 10 - 30 ', ' yyyy - mm - dd '), 1) - 6) from dual')

(TEMQ_1f040dd124f08b2cb2.GZRQ <= 'select trunc(next_day(to_date('
2009 - 10 - 30 ', ' yyyy - mm - dd '), 1) ) from dual'))

第2句多了一个") "

[hebo2005]

回答：
就是括号不对
重点看这两句
(TEMQ_1f040dd124f08b2cb2.GZRQ >= 'select trunc(next_day(to_date('
2009 - 10 - 30 ', ' yyyy - mm - dd '), 1) - 6) from dual') and
(TEMQ_1f040dd124f08b2cb2.GZRQ <= 'select trunc(next_day(to_date('
2009 - 10 - 30 ', ' yyyy - mm - dd '), 1) ) from dual'))
另外你这两句里SELECT为什么用引号啊？这样也会有错误的

[mlc_ren]

谢谢各位