Home » RDBMS Server » Server Administration » illegal relational operator???
illegal relational operator??? [message #373649] Mon, 30 April 2001 03:21
VS
Messages: 9
Registered: March 2000
Junior Member
Hi there,

may be somebody can help me and say why do I get these errors, when issuing a simple SQL with NOT IN:

SELECT * FROM local_table
WHERE id NOT IN (SELECT a_id FROM synonym_of_remote_DB_table)

ORA-00920: illegal relational operator
ORA-02063: preceding line from Remote_DB

IN, EXISTS, NOT EXISTS works fine, but NOT IN - no way.

Thnkx!
VS

Report message to a moderator

Previous Topic: illegal relational operator???
Next Topic: Data type
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 00:27:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.