ORA-00920 error on simple sql query !

From: <samir.vds_at_googlemail.com>
Date: 11 Aug 2006 07:37:59 -0700
Message-ID: <1155307079.802240.90960@i3g2000cwc.googlegroups.com>

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 Received on Fri Aug 11 2006 - 09:37:59 CDT