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 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
