ORA-00920 error on simple sql query !

Giganews Newsgroups
Subject: ORA-00920 error on simple sql query !
Posted by:  samir.v…@googlemail.com (samir.v…@googlemail.com)
Date: 11 Aug 2006

Hey,

I just started my first job last week.

Anyway, I want to run the following sql query on an Oracle database:

select client , kunde , kunden_name , projekt , projekt_name ,
                      angebot , auftrag , bestell_betrag ,
bestell_datum ,
                      erloese , konto , konto_name , buch_periode ,
buch_datum
                      , beleg , lstart , projekt_ende ,
projekt_erstellt ,
                      projekt_status
                from HAUFB0363
                where ( bestell_betrag - erloese ) <> 0

I get the error message: ORA-00920 invalid relational operator.
But with my SQL tool called "TOAD" the query works fine !

I'd appreciate any help

Samir

Replies