Re: ORA-00920: invalid relational operator

From: Ramnivas Chaurasia <ramnivaschaurasia_at_gmail.com>
Date: Tue, 6 Oct 2015 20:00:10 +0530
Message-ID: <CAGwus2XzRuT-Fysitisy9W32Bn5tSMgqrHXHRFd_g3kKrmNQSg_at_mail.gmail.com>

Just a guess. You may have to remove the "order by" clause and check.

Ramniwas
On 6 Oct 2015 7:36 pm, "Jose Soares Da Silva" <jose.soares_at_sferacarta.com> wrote:

> Hi all,
>
> I'm struggling with the following query. It works in postgres but it
> doesn't in Oracle...
>
> (DatabaseError) ORA-00920: invalid relational operator
>
> SELECT unita_aziendale_id FROM (SELECT unita_aziendale.id AS
> unita_aziendale_id FROM unita_aziendale JOIN anagrafica ON anagrafica.id
> = unita_aziendale.id_anagrafica JOIN azienda ON azienda.id =
> unita_aziendale.id_azienda WHERE (azienda.id, unita_aziendale.cod_specie,
> anagrafica.nome) IN (SELECT azienda.id , unita_aziendale.cod_specie ,
> anagrafica.nome FROM unita_aziendale JOIN anagrafica ON anagrafica.id =
> unita_aziendale.id_anagrafica JOIN azienda ON azienda.id =
> unita_aziendale.id_azienda WHERE azienda.id_distretto = '141' AND
> unita_aziendale.data_fine IS NULL AND anagrafica.tipo = 'U' GROUP BY
> azienda.id, unita_aziendale.cod_specie, anagrafica.nome HAVING count(*) >
> 1 ORDER BY upper(anagrafica.nome)) AND azienda.id_distretto = '141' AND
> unita_aziendale.data_fine IS NULL ORDER BY upper(anagrafica.nome)) )
>
> What's wrong with it? any idea ?
>
> j
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 06 2015 - 16:30:10 CEST