ORA-00905: missing keyword

From: jose soares <jose.soares_at_sferacarta.com>
Date: Fri, 11 Feb 2011 13:28:17 +0100
Message-ID: <4D552B61.1040302_at_sferacarta.com>

Hi all,

What's wrong with this query?

SELECT DISTINCT count(*) FROM scadenziario left join operatore ON
scadenziario.id_veterinario_programmato=operatore.id

left join anagrafica     ON operatore.id_anagrafica=anagrafica.id
join unita_aziendale     ON scadenziario.id_unita_aziendale = 

unita_aziendale.id
join anagrafica as aua ON aua.id = unita_aziendale.id_anagrafica WHERE id_piano= 23

it gives me this error:

      cx_Oracle.DatabaseError: ORA-00905: missing keyword

I tried it in PostgreSQL and it works.

Thanks for any help.

j

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

Received on Fri Feb 11 2011 - 06:28:17 CST