Problem with one sentence

Hello

I have a proble with one sentence, it works in SQL Server 7 but not in Oracle 7.3.4 and I don´t know what is the problem.

The sentence is

SELECT CODESCes,COURL,prNOMBes,dencores,DEPARTAMENTOS.DECODCOMP,teNOMBes,COVENTANA

FROM prodservicios, COMPPROD, TEMAS, COMPTEM,COMPONENTES,departamentos

WHERE 1=COMPTEM.CTCODTEM AND COMPPROD.CPCODPS=PRODSERVICIOS.PRCODPS AND 1=COMPPROD.CPCODps AND COMPONENTES.COCoDCOMP=COMPPROD.CPCODCOMP AND COMPTEM.CTCODTEM=TEMAS.TECODTEM AND
componentes.cocdpto=departamentos.decoddep AND COMPONENTES.COCODCOMP=COMPTEM.CTCODCOMP AND COes=1 AND COACTIVO=1

ORDER BY PRORDEN, CODESCes

The SQL Plus say:

ERROR at line 2:
ORA-00920: operador relacional no válido ("Relational operator not valid")

Thanks

Iñigo

----------------------En Castellano------------------

SELECT CODESCes,COURL,prNOMBes,dencores,DEPARTAMENTOS.DECODCOMP,teNOMBes,COVENTANA

FROM prodservicios, COMPPROD, TEMAS, COMPTEM,COMPONENTES,departamentos

WHERE 1=COMPTEM.CTCODTEM AND COMPPROD.CPCODPS=PRODSERVICIOS.PRCODPS AND 1=COMPPROD.CPCODps AND COMPONENTES.COCoDCOMP=COMPPROD.CPCODCOMP AND COMPTEM.CTCODTEM=TEMAS.TECODTEM AND
componentes.cocdpto=departamentos.decoddep AND COMPONENTES.COCODCOMP=COMPTEM.CTCODCOMP AND COes=1 AND COACTIVO=1

ORDER BY PRORDEN, CODESCes

Cuando lo ejecuto en SQL Plus me dice

ERROR at line 2:
ORA-00920: operador relacional no válido

Alguien sabe cual puede ser el problema

Gracias

Iñigo Received on Mon Aug 21 2000 - 10:04:41 CEST