ORA-00905: missing keyword

From: jose soares <jose.soares@xxxxxxxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 11 Feb 2011 13:28:17 +0100

Hi all,

What's wrong with this query?

SELECT DISTINCT count(*) FROM scadenziario

left join operatore ONscadenziario.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

Follow-Ups:

RE: ORA-00905: missing keyword
From: Dominic.Brooks

Re: ORA-00905: missing keyword
From: Subodh Deshpande

ORA-00905: missing keyword

Other related posts: