Home » RDBMS Server » Server Administration » illegal relational operator???
illegal relational operator??? [message #373648] 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: Cursor !!!!!
Next Topic: illegal relational operator???
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 09:44:39 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.